The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

RE: [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.


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




UKHA_D Main Index | UKHA_D Thread Index | UKHA_D Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.