I was curious if anyone new how to create a SQL statement that will read say
an invoice number that consists of 7 digits, only change it to read alphanumeric
values without adding any more places. I believe it involves a case statement
but I cannot figure out how the loop will make it work.

thanks..........