You need to escape the apostrophe first
so
select count(*) from table where field like '%\'%'
On Tue, Mar 25, 2008 at 2:37 PM, Saravanan <[EMAIL PROTECTED]> wrote:
> hi lists,
>
> I want to count the number of rows containing "'" aphostrophe in a
> particular field. I tried with
>
> select coun
hi lists,
I want to count the number of rows containing "'" aphostrophe in a particular
field. I tried with
select count(*) from table where field like "%'%"
i get only 0 counts. but I am sure that exists in many rows.
how to query them
Saravanan
___
