Storing \ in varchar 1

[tommyboyau]

Hi Everyone,
When I generate a varchar with a \ in it, it comes out as a funny symbol and eats a character on the right side of it.
I want to store a filepath in the db. As follows:
Input: 'c:\testData\Reservation.doc'


Any suggestions?

Thanks,

Tom

 

[TonyGroves]

You should double the backslashes:
[tt]
"c:\\testData\\Reservation.doc"
[/tt]
A backslash is used to indicate that the following character is to be treated specially, for example \t is converted to a tab, and \\ is converted to a single backslash.

 

[tommyboyau]

Thanks heaps!