First of all you are correct, the '' in the middle name should be nulls.

In regards to identifying an individual I have to make some choices here. So if it...

Sorry About that. Bad pasting job

CREATE TABLE [#CustomerInfo](

[CustRowID] [int] NULL,

[CustFuzzyGroup_Key_Out_ID] [int] NULL,

[CustLocID] [int] NULL,

[CustNo] [varchar](17) NULL,

[FirstName] [varchar](25) NULL,

[MiddleName] [varchar](25) NULL,

[LastName] [varchar](40) NULL,

[AddressLine1] [varchar](45) NULL,

[City] [varchar](35) NULL,

[State] [varchar](3) NULL,

[ZipCode] [varchar](10) NULL,

[CellPhone]...

Thanks for the help that did the trick. I eventually had to Convert it back to an integer but that got it in the right format.:-)

Thanks for the help and advice. Your solution worked fine. I am also investigating the use of APPLY.

Lutz, thanks for your reply. I think your approach will work best for my situation. I need the Product codes in separate columns to do some additional processing for comsumption...

Lynn, thanks for the response I like your approach. Thanks for the links to the articles. In my situation I think I will you the CTE approach presented by Lutz....

The flat file's only purpose is consumption by the legacy system. I am performing other processing in SQL Server that I did not list. Such as calculating Order totals, spliting...

Thanks for the info!

This is my first post so I apologize for any lack of etiquette.

Your never too old or too young to learn new things and ideas.