Nice question thanks Ron, and good to know that IIF is going to be available in 2012 .. I used to use the syntax a lot in a previous language.

("Shhhh .. be vewwy quiet .. I'm huntin' #div0 errors")

Some careful reading also got me safely past the 'gotcha' of comparing varchar(4) to varchar(1)

but from the same careful reading, a small quibble ... command is I'I'F, and the posted question is titled "I'F'F - 1" :w00t: