Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get same as STRTRAN()
Message
 
 
To
24/06/2008 13:57:30
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01326436
Message ID:
01326442
Views:
19
>>>I need to replace all commas with something else from fields as they are selected from a table using a SQL statement.
>>
>>What about REPLACE() command?
>
>Actually, I think I need to do it on the PRINT statement instead of in the SQL:
>
>
>PRINT
>	@ChartID +
>	',' +
>	@Folder +
>	',' +
>	@DocumentName +
>	',' +
>	@DocDateTime +
>	',' +
>	@ProcessedFileName
>
>
>The @Folder and @DocumentName need to have commas replaced with hyphens.

Doesn't matter:
PRINT

     replace(@Folder,',','-) 
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform