I never knew that... Thank you

BTW - I did download the 2008 Enterprise Edition Eval from Micorsoft and it also throws the same errors in the same order. Could...

Thank you Lowell for all the help. I'm still at the "drawing board" phase of this project, so I look forward to seeing your example and building from there....

Thank you for the post. That is what I ended up doing in the long run was CONVERT both fields to a varchar and concatenating them. Thank you again......

Lowell,

I'm not going to argue with you about giving the customer 700+ columns... But unfortunately, I have to give the customer what they want when they are the ones...

Thank you for posting the code. I need to ask you another question about htis topic. It appears that you are inserting data into the table.

INSERT INTO...

Msg 195, Level 15, State 10, Line 6

'varchar' is not a recognized built-in function name.

This error doesn't make sense at all...

Now I changed the CAST to CONVERT and we're all...

the information that LUTZ gave worked to some extennt. I added the...

DECLARE @RXNUM INT, @RXFILL INT

SET @RXNUM = 10

SET @RXFILL = 2

Then I added a select statement later on...

A little confused, but starting down the right path I think. The Rx_Number is an INT and refill_number is a smallint

So sorry for the delay in my response... We are so close to the completion of this project. This worked like a charm. Thank you very much for...

Sorry, this was my first ever post. Thank you for the heads up and I corrected my posting. 😀