how to use like operator

thillaiarasu · #1 (**permalink**) 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 · #2 (**permalink**) April 20th, 2007, 08:25 AM

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

_________________________
- Vijay G
Strive for Perfection

manish_partey · #3 (**permalink**) April 25th, 2007, 07:57 AM

you can use like after the where condition

jemacc · #4 (**permalink**) 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 · #5 (**permalink**) 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
having problem with Between operator	anantdev	SQL Language	1	May 26th, 2008 08:14 AM
=== operator in c#	surendraparashar	C# 2005	8	November 8th, 2007 05:14 AM
Invalid operator for data type. Operator equals di	Pusstiu	SQL Server 2000	2	August 10th, 2007 04:51 AM
intersect operator	kapy_kal	XSLT	1	March 29th, 2006 02:02 PM
Use of return operator.	PC	BOOK: Professional JavaScript for Web Developers ISBN: 978-0-7645-7908-0	3	July 1st, 2005 09:54 AM