Re: Converting yes or no to one letter strings.

On Tue, 4 Jun 2019, David G. Johnston wrote:

> Actually, given that "f" is becoming multiple different values it seems
> like the OP is improving upon their data model. That should very much be
> done at the table level at not relegated to views, let alone a UI layer.
>
> It is not unusual to want to convert something that was a simple boolean
> to an enumeration of values. Though it is probably better to add a new
> column to reflect the new model element and effectively deprecate the old
> column - eventually removing it from use when it is no longer needed.
> Altering the column type, while possible, is not usually desirable. In
> particular it makes rolling back (or supporting older) client software
> more difficult because the old version will not recognize the new field
> and the old field will be gone.

David,

Thanks for the insights.

Rich