ADSM-L

Re: syntax for using "like" in select statement?

2002-08-13 13:40:12
Subject: Re: syntax for using "like" in select statement?
From: "Williams, Tim P {PBSG}" <Tim.Williams AT PBSG DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 13 Aug 2002 12:39:39 -0500
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

<Prev in Thread] Current Thread [Next in Thread>