Re: Converting yes or no to one letter strings.

[Ray O'Donnell]

On 4 June 2019 23:30:33 Lou <l...@dayspringpublisher.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;