Most likely the name is returned as Unicode. You can use STRCONV(,6) to convert it into ANSI.
>I running a query that returns a result set that have the database name,date/time and backup location of each database on the sql server that has been backed up. It works great, but in the backup location, it returns a field that on the screen looks great and readable, but when it prints, it has extra spaces between each letter:
>
>
>screen: d:\sqldata\ctore.bak
>
>print: d : \ s q l d a t a \ c t o r e . b a k
>
>
>Anybody know what causes that and a way to get rid of that behavior. It's like it double-byte or something.
>
--sb--