Re: syntax for using "like" in select statement?
2002-08-13 13:40:12
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:adsmigmo AT YAHOO DOT COM]
Sent: Tuesday, August 13, 2002 12: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
|
|
|