> I have a field which contains a value, say 0,1,2,3,4,5
>
> Now if the value is 0, I want to display the letter B, if the value is 1,
> then I want to display the letter O, if it's 2 I want to display E, if it's
> 3 oh you get the idea.
>
> I want to display this within a select so that the number is
> retrieved, and the letter is displayed. Anyone know a simple way
> to do this?

Create a extra table with the lookup's.

LOOKUP
NUM = LET

and then use an inline select

( SELECT LET FROM LOOKUP WHERE NUM = MAIN.NUM ) AS LETTER

I use this a lot so that the customer can change the names
of queues or displays. They just edit the LET entry in the
lookup table.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services