Re: Safe to allow ' character in varchar fields?

Hi Adrian!

I store names like D'AMBROSIO or O'NEAL since '96 in a VC2(100) field, no problem!

Select:
WHERE mycol LIKE '%''%'

Robert

Adrian Harrison schrieb:

> I have a request by users to allow ' in varchar2 fields
>
> At the moment I stop them entering this character as it's used to denote strings
>
> Is it safe to allow it to be saved in to these fields or not?
>
> Also how would you do an SQL wild card search on field that contain wildcard characters?
> Is this the way to do it "select * from mytable where mycol like '%%'; ?
>
> Thanks
>
> Adrian Harrison
Received on Wed Feb 03 1999 - 07:19:37 CST