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:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 1:26 PM To: [EMAIL PROTECTED] 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
