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

From: Terry Sullivan <terry_sullivan_at_sgsgroup.com>
Date: Fri, 11 Jun 1999 11:28:22 +0100
Message-ID: <7jqob1$k7p$1@lure.pipex.net>

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

Use two single quotes for each quote mark that you are looking for - e.g.: SELECT * FROM TABLE WHERE COLUMN_NAME = 'NAM''E''S'; Received on Fri Jun 11 1999 - 05:28:22 CDT