string format in SQL -- sql server odbc

clark
9/22/2004 8:20:59 PM

I was using the following command to update the data
source (a tab-delimited text file):

INSERT INTO table (COL1,COL2) VALUES ('AA','BB')

I found the updated text file looked like this:
"AA" "BB"

Could anyone tell me how to remove those double quotation

GTR_Legend
9/30/2004 4:17:25 PM

Try the replace command
eg
INSERT INTO table (REPLACE(COL1, '"', '')),(REPLACE
(COL2, '"', '')) VALUES ('AA','BB')

That might work, but i haven't tested it

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : string format in SQL