Yup. When the UID is created, store it however it was entered, then UPPER every time the user logs in. PWD, however, should be case sensitive.
>Thank you. So when the program checks for a duplicate user name, the UPPER() should be applied too, right? So that not two records could have "John Smith" and "JOHN SMITH".
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer