In the place where you would drag and drop one column, you can use a SQL
OEM "if" statement or a case statement like Jeroen mentioned above. I
have done both but tend to use case statements more.

CASE room
WHEN '135' THEN 'Room 135'
WHEN '085' THEN 'Room 85'
ELSE 'No Room, must be basement'

If you really need an 'if', give me an example of the query and if it is
oracle, sql, etc.

tisenberg's Profile:
View this thread: