Yes, I'm selecting and concatenating all fields from both tables and inserting to a third one with only one column - that's how the client want it.

It actually eats up...

Jacob,

Thank you very much. The FOR XML PATH link you directed

me to worked like magic.

Thank you. U made my WEEK!!!!!:)

Can you help me with a scaler function that will work with the table structures I posted, please? I'm a newbie and not too familiar with string functions.

o you know how to use FOR XML PATH ?

When I use CAST it turns a 10 digit phone

number into this - 5.19753e+009.

You are very right, Luke.

The file is for a client and they

dictate how they want it.

Concatenating numbers and text and delaing with nulls

is crazy.

Thanks for your help. It worked

Thanks. The application is a windows not a web app

I realized I can't use that view because the password is encrypted.

is there a way around this?