HI all,

I have to write a SQl Script which will be checking the users for which the Passwords are not defined. This includes the blank spaces (if password is all white spaces, its also treated as blank). In Sysxlogin table, the password is Varbinary. For no passwords, I can check for 'NULL'. But for ' ', I have to look for..??

Hope you got my problem. In other words, how to check if a password for 'sa' or any other user is NULL / Blank Spaces only, how to detect such users.

Hope to have an expert advice so quickly...))

Thanks.

B. Anant

__________________
B. Anant