Re: Using ' character in string in where statement

From: Steve Rainbird <steve.rainbird_at_nospam.mssint.com>
Date: Fri, 17 Jan 2003 10:10:23 +0000 (UTC)
Message-ID: <b08kqf$j9a$1@helle.btinternet.com>

"Christian Svensson" <chse30_at_hotmail.com> wrote in message news:ccc2a7eb.0301170203.13eaf3f2_at_posting.google.com...
> Greetings,
>
> I hope someone can help me with this maybe "stupid" question. I have
> looked at otn and in this newsgroup but cant find anything.
>
> If I want to use a ' character in the string in my where statement,
> how do I do then ?
>
> for example select something from some_table where some_col = 'my '
> character'
>
> Thanks for any answers.
>
> Cheers !
>
> /Christian

Christian,

use 2 quotes where you want the single quote

e.g..

select something from some_table where some_col = 'my '' character'

Regards

--
Steve Rainbird
Principal consultant
MSS International Ltd.
www.mssint.com

Remove "nospam" from email address to reply

Received on Fri Jan 17 2003 - 04:10:23 CST