ALZDBA

Ian is correct to himself not me because both of us are not from the same company and same department and differnt country.

My company SQL SERVER table TestCustomers DataType for CustomerID is VarChar so it's not Integer. Unless you don't understand english as I did mentioned that CustomerID datatype is Varchar in respond to IAN suggestion.

So, you better be careful with your driving and be sensitive to your environment and do not take event for granted.

As per your statement I do not understand what you are suggesting as there are no sample coding to provide logical explanation like the other helpers did. They are good providing sample coding which they think is correct logical. They are good driver.