Safe to allow ' character in varchar fields?

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 - 06:49:58 CST