Re: Converting yes or no to one letter strings.

Something like the following should work:

ALTER TABLE ... ALTER COLUMN ... TYPE text USING (CASE WHEN ... THEN 's' ELSE 'f' END);

Though at this point you are probably better off creating a category table with a primary key and converting this column to be a foreign key.

David J.