Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
OBINNA_EKE
Posting Yak Master
234 Posts |
Posted - 2006-09-20 : 09:18:41
|
How do I convert thisMyVar = G:\VCaP\Documentation\SRD\VcapFileTest\DraftWhy MBA.docToMyVar = G:/VCaP/Documentation/SRD/VcapFileTest/DraftWhy MBA.docin SQL 2000 FUNCTIONI need the function please ie change forward slash to backwords slashIf it is that easy, everybody will be doing it |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-20 : 09:20:38
|
[code]select @MyVar = Replace('G:\VCaP\Documentation\SRD\VcapFileTest\DraftWhy MBA.doc', '\', '/')[/code]Harsh AthalyeIndia."Nothing is Impossible" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|