select * from sometable where somecolumn like '%partofname%'

If you know the begining, you can leave off the first %.
Remember that in many cases, the column data is case-sensitive, and you may
need to use PARTOFNAME.



-----Original Message-----
From: Michelle DeVault [mailto:adsmigmo AT YAHOO DOT COM]
Sent: Tuesday, August 13, 2002 1:26 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: syntax for using "like" in select statement?


I'm sure this has been answered before, I just can't
find it in the archived on adsm.org.

How can I use a "like" in a select statement?  I don't
know the value exactly, just know a portion of it.

ex.
select * from sometable where somecolumn like somevalue

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com