That is probably a good idea, but I still have to use chars as my datatype, because the codes are alpha numeric. Most of the time they are just numbers, but there is always at least one or two partially or totally alpha codes.

Thanks for the suggestion. I will research implementing Nulls instead of the % that I am currently using.