3 Comments on “Which keyword should you use in your where clause?”

1. Sven says:

   September 30, 2016 at 9:53 am

   BETWEEN and FIND don’t make sense.
   LIKE is the correct answer.

   
   
   
   2

   
   
   
   0
2. Amit says:

   August 1, 2017 at 10:33 am

   Keyword in the statement is ‘contains a specific character’ you can only use ‘like’ for a specific character.

   Between operator selects values within a given range. Where Price is Between 10 AND 20.

   
   
   
   2

   
   
   
   0
3. avalon333 says:

   November 10, 2018 at 7:26 am

   D, Like is correct.
   But you should use % % probably, otherwise only find exact input.

   Example:

   SELECT *
   FROM dbo.Album
   WHERE AlbumTitle LIKE ‘%T%’;

   
   
   
   2

   
   
   
   0