Working with Like Operator.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 238
--Like operator with 5 character ling in FIRST_NAME(we have to give 5 times underscore)
SELECT * FROM EMPLOYEE-MASTER WITH(NOLOCK) WHERE FIRST_NAME LIKE '_____';


--Like operator with 7 character ling in FIRST_NAME(we have to give 7 times underscore)
SELECT * FROM EMPLOYEE-MASTER WITH(NOLOCK) WHERE FIRST_NAME LIKE '_______';

Comments or Responses

Login to post response