After review, I looked at the INSTR function mentioned. I ended up with this:
Code:
SELECT
CASE INSTR(@ProductType,"Server")
$PT = "Server"
CASE INSTR(@ProductType,"Controller")
$PT = "Server"
CASE 1
$PT = @ProductType
ENDSELECT


I know this will not handle non-PDC/BDC NT 4 Servers, but we do not have any in place, so that wouldn't matter as much. This does seem better, and I am always wanting to learn better ways to do things. I am not a programmer, nor do I try to pretend to be. That is why I ask for help. Most of you guys are much better at this than I will probably ever become.