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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Replacer

Author  Topic 

OBINNA_EKE
Posting Yak Master

234 Posts

Posted - 2006-09-20 : 09:18:41
How do I convert this

MyVar = G:\VCaP\Documentation\SRD\VcapFileTest\DraftWhy MBA.doc

To

MyVar = G:/VCaP/Documentation/SRD/VcapFileTest/DraftWhy MBA.doc

in SQL 2000 FUNCTION

I need the function please ie change forward slash to backwords slash

If 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 Athalye
India.
"Nothing is Impossible"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-20 : 09:20:53
See also
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72279


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -