Although I realised that this was another silly question which was going to have an answer which was language specific, inflexible and basically stupid, my immediate thought was to use Boolean algebra. 🙂

Since 'A OR B' can alwasy be rewritter as 'NOT (NOT A AND NOT B)' then the (still silly) solution of

where

mob = 1

or mob = 3

or mob = 4

or mob = 5

or mob = 7

or mob = 8

can be rewritten aswhere not (

mob <> 1

and mob <> 3

and mob <> 4

and mob <> 5

and mob <> 7

and mob <> 8

)

Which satisfies the (poorly specified) requirement of using neither IN nor OR. 😀