what is the use of like query?

Question

select count(*) from query where queryname like '% + query + %' please explain what is the use of this code? '% + query + %' so this query is the particular word to searched for matching

Jaganathan Bantheswaran · Answer

Hi Consider the query = XXX; the above query will return the total num of records which having the word 'XXX'. The COUNT(*) function returns the number of records in a table.

Amit Choudhary · Answer

hi friend The run time output of this query from the c# code will be like this. query variable's value will be like below: select count(*) from query where queryname like '%Query1%'; it works as a contains function cause you have applied % on the both side of the query variable. Hope you got the idea. Thanks. Please mark Do you like this answer if it helps you.

Suthish Nair · Answer

If the query got resolved then mark the post that helped you as Answer so will be helpful for others.

Suthish Nair · Answer

http://msdn.microsoft.com/en-us/library/ms179859.aspx

Syed Shakeer · Answer

Hi I will return matching records based on Like condition