Re: search for 's string in database

select *
from tablename
where somefield like '%''s';

or

select *
from tablename
where somefield = 'Paul''s';

"pk" <paul.kavanagh_at_exceptis.com> wrote in message news:8t8uvq$at$1_at_kermit.esat.net...
> Hi,
> I'd be grateful if anyone can help me write a sql to search
> for the following in a database ..... 's
>
> eg
> 'the cardholder's amount'
>
> I want the sql to reaturn where this appears in the database
> Can this be done through sql or does it have to be a pl/sql block ?
>
> thanks in advance for your help
>
>
Received on Thu Oct 26 2000 - 17:26:21 CDT