Thanks everyone for the suggestions and help. Ken's suggestion worked just fine.

Thanks again,

Mike

Sorry for the confusion. I was trying to state how the product codes are stored and show the code structure. Let's stick with a code starting with 12, if no...

Lynn,

The product code is stored as alpha numeric. The code could be 12AB or AB12. The ideal soluntion would to get the next available column for last character the user...