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



Tawn, Jonathan wrote:

> All - thanks for your quick replies,
>
> i'm getting an error (under ie6) which looks like this:
>
> 'expected case'
>
> J.
>
> -----Original Message-----
> From: UKHA [mailto:ukha@xxxxxxx]
> Sent: Tuesday, 01 June, 2004 13:21
> To: ukha_d@xxxxxxx
> Subject: RE: [ukha_d] [OT] SQL Select statement
>
>
> Jonathan
>
> select field1, field2 from table where field1 like
"%string%"

If you're using MSSQL you need to use ' rather than " for the string
as
someone else posted. :-)

--
Doogie



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.