RE: [OT] SQL Select statement

["Tawn, Jonathan" <jonathan.tawn@xxxxxxxxxxxxxxxxxxxx>]

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
**********************************************************************