Haha. Just in case something new comes up. I have a select statement that will pick up any conditions where the ELSE would be met. Haha. Thanks again.

It all works! I've tested the update query successfully with employing a CASE statement like this:

UPDATE rm00101

SET userdef2 = (CASE cc.mso_respcode

WHEN -12 THEN rm00101.userdef2

WHEN -31 THEN rm00101.userdef2

WHEN 0 THEN rm00101.userdef2

WHEN...

Thank you for your assistance, it means a lot! I will go ahead and attempt this. Something I did leave out it that I will have to do a CASE...