>>>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.
The same:
PRINT
@ChartID +
',' +
REPLACE(@Folder,',','-') +
',' +
REPLACE(@DocumentName,',','-') +
',' +
@DocDateTime +
',' +
@ProcessedFileName
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
