SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Replacer
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

OBINNA_EKE
Posting Yak Master

234 Posts

Posted - 09/20/2006 :  09:18:41  Show Profile
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
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 09/20/2006 :  09:20:38  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message
select @MyVar = Replace('G:\VCaP\Documentation\SRD\VcapFileTest\DraftWhy MBA.doc', '\', '/')


Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30218 Posts

Posted - 09/20/2006 :  09:20:53  Show Profile  Visit SwePeso's Homepage
See also
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72279


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 09/20/2006 09:22:06
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000