Re: How do you do an SQL query for data that has '' in it ?

From: Kurt Laugesen <kul_at_post3.tele.dk>
Date: Thu, 10 Jun 1999 12:26:57 +0200
Message-ID: <7jo42d$7vb$1@news.inet.tele.dk>

SELECT * FROM
TABLE WHERE COLUMN_NAME = 'NAM\'E\'S'escape'\' should do the trick

In the above you explicitly say that \ is the escape-character, but that is probably default anyway
Hope this helps
Regards
Kurt Laugesen
kurtL_at_corebit.dk

Andrew Fisher wrote in message <375F8BB1.1B1A5891_at_uk.ibm.com>...
>I have a problem in that I need to use an SQL statement 'SELECT * FROM
>TABLE WHERE COLUMN_NAME = 'NAM'E'S'
>
>Basically the data in COLUMN_NAME has single speech marks in it - This
>inevitabally causes problems for SQL. Does anyone know what SQL can use
>to ovecome data with single speech marks.
Received on Thu Jun 10 1999 - 05:26:57 CDT