Paul,

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

Any chance to do it on the client side? In Delphi I would use something
like the OnGetText event of a Field object.

Otherwise, I think a stored procedure is the easiest thing. A slightly
more difficult (but perhaps more clean) approach would be to jeft join
to a lookup table:

key desc
0 B
1 O
2 E
3 ...

HTH
--
____
_/\/ando