how to use like operator

thillaiarasu · April 20th, 2007, 07:05 AM

hello i am a beginner in sql server.In my project i want to search the persons vi account number or by there name so how should i use the operator like in query

With Regards,
N.ThillaiArasu

n.thillaiarasu

happygv · April 20th, 2007, 08:25 AM

Did you check Books online(BOL) for its syntax?

_________________________
- Vijay G
Strive for Perfection

manish_partey · April 25th, 2007, 07:57 AM

you can use like after the where condition

jemacc · April 25th, 2007, 08:53 AM

It is used for search matching or pattern matching
select like, from, what from booksonline
WHERE yourcolumn like '%comparison'

Jaime E. Maccou

jack_hilary · April 23rd, 2010, 09:47 AM

Hello there,
the like statement will match the substring in your database you have specified in your query.
suppose you want to extract data from example table and you have a text control txtBox where you have entered into the account number/ name or any thing you wish and wanna select Id of that selected record then use the following query

Code:

select Id from example where Name like '%" & txtBox.Text & "%' "

Hope this helps.