Link to home
Create AccountLog in
Avatar of mgmhicks
mgmhicks

asked on

How to remove double quotes

I just updated to sql2008.  Most programs work well.  However when I create a dataset my fields now have double quotes so when I go and create the following line it has mess'es up.  Can someone give me a solution around this.

 myFile = "c:\DataDrive\closereports\Dec2010 Transfers\GLTransFer-'" & RTrim(mydS.Tables(0).Rows(x).Item(0)) & "'-12292010.txt"

it ends up looking like this>
"c:\DataDrive\closereports\Dec2010 Transfers\GLTransFer-'"B1"'-12292010.txt"

because the data is double quoted and sql 2000 it wasnt.

thanks

ASKER CERTIFIED SOLUTION
Avatar of ALaRiva
ALaRiva
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of mgmhicks
mgmhicks

ASKER

thanks worked great