forum

Home / DeveloperSection / Forums / How to use like clause? Is it possible to use it with INT data type variable?

Ask Question

How to use like clause? Is it possible to use it with INT data type variable?

Jonas Stuart135030-Sep-2016
Hi Buddy

How to use like clause? Is it possible to use it with INT data type variable?
Please explain me.I would really appreciate your help.

Thanks


c#c# 
Updated on 30-Sep-2016
Jonas Stuart

Jonas Stuart

Follow

Can you answer this question?

Answer

1 Answers

Abhishek Srivasatava

Abhishek Srivasatava

30-Sep-2016

 Hi Jonas, 

Yes, it is possible to use like command with Integer data type verified in SQL server 2008 .


SELECT *
FROM Ee_empl_cat4
where
prsn_intn_id  LIKE '10%'


answer 519983009124120


Use of like statement with different Wildcard :


SELECT DISTICT  A.PRSN_ADHAR_NUM
FROM ADHAR 
WHERE NAME LIKE 'P%' -- this statement fetch all those record whose name is start with ‘P’. 
OR City LIKE '%A' -- this statement fetch all those record whose name is ends with ‘A’.
OR City LIKE '%ank%'-- this statement fetch all those adhar number whose name contains ‘ank’ in between their number. 
OR City NOT LIKE 's%'
OR City LIKE ‘R_S_I_E_H’ -- this statement is used to find the city name start with R followed by any text, followed by ‘S’ followed by any text, followed by I followed by any text, followed by E followed by any text and string last letter will be H. Wildcard ( _ )  is like a substitution for any alphabet.
OR  City  LIKE '[abc]' -- fetch all those city name which start with a,b,c.
OR  City  LIKE '[a-c]' -- fetch all those city name which start with a,b,c.

 

Liked By