RE: [OT] SQL Select statement

["UKHA" <ukha@xxxxxxxxxxxxxxxxxxxxxxx>]

Jonathan

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

HTH

Andy

*********** REPLY SEPARATOR  ***********

On 01/06/2004 at 12:50 Tawn, Jonathan wrote:

>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.
>
>
>**********************************************************************
>This e-mail:
>
>is not contractual nor shall it be taken to create any legal
>relations, contractual or otherwise.
>
>represents the personal views of the author / sender. The
>author / sender has no authority or delegation to bind The
>Department for Work and Pensions by this e-mail and The
>Department for Work and Pensions accepts no
>responsibility whatsoever for its contents.
>
>is communicated in confidence.  It is intended for the
>recipient only and may not be disclosed further without
>the express consent of the sender.
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>
>This footnote also confirms that this email message has been swept by
>MIMEsweeper for the presence of computer viruses.
>
>www.mimesweeper.com
>**********************************************************************
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>