Working with Like Operator.

Posted by vishalneeraj-24503 under Sql Server category on 11/24/2014 | Points: 40 | Views : 772

--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 '_______';

Bookmark It

Latest Code Snipptes