On 4 June 2019 23:30:33 Lou <lou(at)dayspringpublisher(dot)com> wrote:
> Hi everyone,
> Is it possible to convert a boolean yes or no field to hold a one letter
> string? For example, the strings: 's' 'f' 'p' 'e'
> To start off, I just need to convert true to 's'. false will have to be
> manually changed to 'f' or 'p' or 'e' as appropriate.
> Lou
select case when (boolean variable) then (whatever) else (whatever else) end;