CREATE VIEW myview
AS
SELECT item1, item2, CAST (CASE WHEN item3=1 THEN 'T' END CHAR(1)) as TF
FROM TABLE1