Re: Single quote?

From: nick <nick-love_at_juno.com>
Date: Thu, 01 Mar 2001 04:30:03 -0000
Message-ID: <t9rk2bnb376p07_at_corp.supernews.com>

Peta Griffith wrote:
>
>
> Does anyone know how you look for a single quote in a text field? (do
 you
> place other quotes around it?)
>
> Thanks!
>
> trying using the wildcard command to find the single quote...

  try something like this: SELECT column_name

                            FROM table
[Quoted]                             WHERE column_name like '%'%';

 i'm not sure if it'll work,but give it a shot..

--
Posted via CNET Help.com
http://www.help.com/

Received on Thu Mar 01 2001 - 05:30:03 CET