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

From: <shiling_at_math.wayne.edu>
Date: Thu, 10 Jun 1999 12:15:45 GMT
Message-ID: <7joa9a$g8v$1@nnrp1.deja.com>

Use double single quotes will do the trick. See below.

SQL> select * from t
  2 where a1='who''s this';

A1

---

who's this

In article <375F8BB1.1B1A5891_at_uk.ibm.com>,   Andrew Fisher <fishera_at_uk.ibm.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 10 1999 - 07:15:45 CDT