At 10/25/2001 02:44 PM (Thursday), Paul Schmidt wrote:

>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?

I expect you haven't considered putting these values into a table because
there are so few but that's what I would do. Make a table of integer values
and their corresponding letters. Then use a standard join to lookup the
letter for each integer value. A sub-select would also be possible.