>>>>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,",","-")
NO with double quotes :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.