>>>>One more question - why in the UPDATE statement where is
>>>>username = lower(@username) ? Why do we use lower is SQL Server is case insensitive ?
>>
>>He is setting it to lower all over the palace and storing it as lower, because SQL Server IS case SENESITIVE.
>>
>
>No, it's case insensitive. I just tried

Wow... major whole in my understanding of MSSQL thank you for checking that!!!!!

You may have just saved my a** at some point in the future.

I learn something new every day <g>

Thanks!

It is possible to set the server to be case sensitive, by changing the colation. So maybe that is why he was doing that?