Re: [OT] SQL Select statement

["Paul Robinson" <ukcueman@xxxxxxxxxxx>]

try this:

select field1, field2 from table where field1 like '%string%'

HTH
Paul

----- Original Message -----
From: "Tawn, Jonathan" <jonathan.tawn@xxxxxxx>
To: <ukha_d@xxxxxxx>
Sent: Tuesday, June 01, 2004 12:50 PM
Subject: RE: [ukha_d] [OT] SQL Select statement


> apologies for the OT post,
>
> but i know there are some SQL gods out there ....
>
> i'm trying to do a select statement as below,
>
> select field1, field2 from table where field1 contains
"string"
>
>
> this is from an .asp webpage and it dont work ... what am i doing
wrong ?
> its for trying to find a keyword within a field then to disply that
said
> field.
>
> any help / thoughts / etc most appreciated.
>
> mucho thanks,
> jt.