Re: LIKE function
From: Jeff Kish <jeff.kish_at_ait-mmii.com>
Date: Wed, 06 Feb 2002 09:24:58 -0500
Message-ID: <m0f26u8gq0qjf6vfp0p712mes5a28bb4nh_at_4ax.com>
Date: Wed, 06 Feb 2002 09:24:58 -0500
Message-ID: <m0f26u8gq0qjf6vfp0p712mes5a28bb4nh_at_4ax.com>
Yup.
select column1 from table where column 2 like 'value%' gets every column1 value from a table where the corresponding column2 value starts with 'value'
I think this is actually standard sql.
To quote "A Guide to SQL" by Philip J. Pratt,
'The symbol "%" is used as a "wild card."'
Jeff
On Tue, 05 Feb 2002 19:56:09 GMT, Bricklen <bricklen_at_shaw.ca> wrote:
>hmmm... why, yes there is.
>
>(sorry if I seem a bit snarky. that question shows that you did zero
<snip>
>> Thank in advance.
Received on Wed Feb 06 2002 - 15:24:58 CET