I have tried that as well you just get Error converting data type varchar to float.

Thanks....that works great!!!

I got the following error.

An INSERT EXEC statement cannot be nested. [SQLSTATE 42000] (Error 8164). The step failed.

Do know what I am doing wrong. This could be a...

Thanks for you help....I have learned a lot.

Chad

Bob,

I need it to output like this (789) 567-8907?

Thanks.

Full

Sorry about posting in the wrong place! Thanks for your help?

Chad

I am on using 2000 SQL.

The auth table looks like this

userid

, username

, password

, type_gateway

, dt_pubactive

, dt_pubexpire

, status

The password table looks like this:

auto number

, dt_create

, userid

, password

I would like to delete the oldest password that is correct.

Chad

I have 63.8 GB free on the physical drive. I am pulling and converting data from and oracle database into my SQL database.

Chad

Thanks!!!! That works prefect!!

Chad

Thanks for the help. We have decided to go the password route. I like that idea the most...seems to work very well.

Chad

Thanks for your help....that seems to do just what I wanted.