Hai all.........
I have just added a csv file into my table in sql server....
The problem is all the values are encoded within quotes...
for Ex:
"1" "195.32.45.1" "124.25.35" "tcp"
somethin like...It is difficult for me to use the datas in my code...
I want to remove the double quotes..I cant do it manually as i have a large dataset...
Help me please..
Loading
Jan MontanoPosted Jan 26, 2009, 10:12 PM
you could execute an update sql statement in your table
//do a select first to be sure
select field,* from table where field like '"%"'
//update table
update table set field=substring(field,2,len(field)-2) where field like '"%"'