Yes. There was data in the table.

Once I deleted them, it ran fine.

Thanks for saving me a lot of time with this.

Appreciate the help.

Arun

I will try these suggestions. I am sure there is pre-existing data, which should not be there!

Thanks much.

The script is being used to insert values into this lookup table.

The error happened when testing the scripts to create a database, with all the tables etc.

The 'INSERT' is the...