Gerard O Carroll (10/28/2011)
In the past, on some lookup type tables, I was getting inconsistent results if I had a table with a VarChar. If I chenge it to Char , seemd to fix it, I assum it was something in the VarChar to do with trailing spaces. It might be worth a try
Thanks for trying to help. That problem was solved a few hours agao. I was just wondering if there was an easy was to populate the drop down lists so that they would automagically right trim the items and act like they were case insensitive.
If there is no EASY way, I am not really interested 
Have a great weekend!