cleansing data

mary10k · #1 (**permalink**) 11-11-04, 11:17

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?

Thank you.

Pat Phelan · #2 (**permalink**) 11-11-04, 16:12

Using which database engine? The string operations aren't very standard between engines, so which engine makes a considerable difference.

-PatP

mary10k · #3 (**permalink**) 11-11-04, 16:49

Using MS SQL Server 2000

Madhivanan · #4 (**permalink**) 11-12-04, 07:36

Hi mary10k, try this

Code:

update tablename set filedname=replace(filedname,""" ""","")

Madhivanan

Internet Services

Web Development

Digital Marketing

Consumer Tech