Again, thank you. But since day 1 (many years ago) I always applied UPPER() to the password, my app passwords are not case sensitive. So I will have to see if I will change it.
>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".
>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham