ja, but because your excluding hostnames and because it involves multiple conditions, I would suggest that a SELECT statement would be over-kill and not pratical anyways ... it would end-up just looking like the IF state above anyways, with more lines of un-necessary code ... like this:

Code:

SELECT

 CASE @WKSTA <> "Jooel" AND @WKSTA <> "Shawn" AND @WKSTA <> "Ron"

   ; do something

 CASE 1

   ; do nothing

ENDSELECT


You can't break each case out into its own case statement, because you need to check for all three hostnames at once. Anyways, if this is just a quick-hitter thing would suggest you stick with the above or DOC's code.

-Shawn