var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: cleansing data
I have a table with 1.5 million rows. Each field has a text qualifier of " ". Could you please tell me if and how I can write a script to remove the quotes from each field?
Using which database engine? The string operations aren't very standard between engines, so which engine makes a considerable difference.
Hi mary10k, try this
update tablename set filedname=replace(filedname,""" ""","")