First off, Select statements should have a default Case as well. I wonder though, why you even need a Selct Case construct to map home drives if you use @UserID in the Use command.

Also, the brackets are not needed (@userid = "STUDENT1") to force precedence.

{edit: Beat out by the master}


Edited by Les (2003-12-18 09:23 PM)
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.