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