When looking at the code I noticed that you have the Drop Table at the top of the Query. Move the drop table to the bottom of the query...

Hi Flo,

Thank you for your suggestions.

Don

Hello I took your code and made the following changes to it

--Create Temp table to load converted data

Create Table #Temp

(

col1 char(1),

...