Got it - Thanks for looking though !!

Yes,

I highlighted it here for you.  This is one of my many and varied attempts to get something to work.  I have learned that the 'char(14)' should be datetime...

Here is the whole ball of wax, the error messages are from query analyzer where I just segment out the portion that I show you:

SELECT     Return_No, Serial_No, Model_No, Combo_No, RTRIM(LTRIM(Cust_Cmt1))...

Chris,

I don't know if I can.  I have this in the middle of my query for my DTS.  I have imported a BW table directly to an interim table in...

thanks for your prompt replies

Chris -  Date_Created varchar 50 and  Time_Creat varchar 50 

Peter, I get this for an error message when I run your version:

Server: Msg 174, Level 15, State 1, Line 1

The stuff function...