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 |
|
edojan
Starting Member
4 Posts |
 Posted - 2011-01-07 : 15:47:17
|
| ok i have a UNC path that has spaces and ex "\reporting & Analysis\_weekly\arp report" how do i code this in sql so that it dosent give me errors since it has special characters ...Thanks!! |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-01-07 : 15:55:16
|
| What do you mean by code it? Why would sql care if a string ha special characters? Or are you doing some string manipulation or dynamic SQL that is causing issues?http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
edojan
Starting Member
4 Posts |
Posted - 2011-01-07 : 15:59:34
|
| I meant to code it ... perhaps its my code. But if SQL dosent care if the UNC path you are referencing (string) has special characters thatn my programmer lied to me :) Sorry for stupid question lol Thanks! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-08 : 01:11:02
|
| probably you could give us some background on what your programmer was trying to achieve!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-01-12 : 03:10:20
|
| Post the code that gave the errorMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Special Characters in UNC