Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to get same as STRTRAN()
Message
 
 
À
24/06/2008 13:57:30
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01326436
Message ID:
01326442
Vues:
20
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform