Thanks for your quick response and infact I was wondering if there is any built function to do the same instead of case statement.

Thanks.

Login falied for user 'user1'.

This is the error I am getting and my database box is configured for mixed mode authentication.

I could not access security node at