>>>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