How to Write LIKE Operator in SQL Server

How to Write LIKE Operator in SQL Server

 #like,#srilanka,#vlogs,#blogs,#top,#update,#select,#query,#restoredatabse,#backups,#database,#table,#sql,#sqlserver,#insert,#datascience,#techinsrilanka,#dbms,#blogging,#insertdata,#sql #average #function,#avg

Thank you !!!