var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how do u filter out " ' " (apostrophe)?
i'm trying to remove all the ' from a dataset
update A set room = replace (' ' ', '') where room like '% ' %'
but you can't because ' is reserved in oracle to delimit strings and characters..
how would i be able to do this???
If you need to represent a single quote inside a string, put 2 single quotes:
select replace('john''s', '''', '_') from
Last edited by ss659; 10-25-04 at 13:02.
Oracle OCPI (Certified Practicing Idiot)