Here's a couple of examples: select drive_name from drives where online not like 'YES'
select current date as tmpdt, count(*) volume_name, stgpool_name from volumes - group by stgpool_name having stgpool_name like '%TAPE%' -----Original Message----- From: Michelle DeVault [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 12: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