Replace string not working 2

[vba317]

I am trying to write a replace string to replace the characters ;" & _ with ;" I currently have
I was a little confused on the proper character for " I hope it is Chr(148). Any help would be apprecaited.

strSQL = Replace(strSQL, Chr(59) & Chr(148) & Chr(32) & Chr(38) & Chr(32) & Chr(95), Chr(59) & Chr(148))

 

[Andrzejek]

is Chr(34), so:
[tt]
strSQL = Replace(strSQL, ";" & Chr(34) & " & _", ";" & Chr(34))
[/tt]

Have fun.

---- Andy

 

[PHV]

strSQL = Replace(strSQL, ";"" & _", ";""")

FYI, " is Chr(34)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886