I have a table that includes a Yes/No Boolean field "is_dev". There is also a query that does the following:
Code: Select all
CASEWHEN( "is_dev", 'devisee', 'heir' ) AS "status"
" . . . devisee." or ". . . heir ." Note that there are spaces after the shorter word. It appears that the field is a fixed length based on the length of the longest possible result.
Is there a way to modify my query to change this result?
Thanks for any thoughts.