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


__________________________________________________ __________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i...Dypao8Wcj9tAcJ