Thank you so very much !!!!...

This works perfectly !... Exactly as I needed.

Hi,

Thank you for sharing your valuable time with me on this, it is greatly appreciated.

Here is what I am trying to do ..

-- Build target table

CREATE TABLE [dbo].[_tbl_Target](

[ACCOUNT_NAME] [varchar](50)...

Thank you very much for your reply.

I am still curious to know if there is a way to do this with a CASE statement and avoid the CURSOR route....