Re: Cast on character columns in views

--- "Luiz K. Matsumura" <luiz(at)planit(dot)com(dot)br> wrote:
> CREATE VIEW view1( id, col1, type1, type2) AS
> SELECT table1.id,
> table1.col1,
> CAST( table2.type1 AS CHARACTER( 3 )),
> NULL
> FROM table1
> JOIN table2 ON table2.fk_table1 = table1.id
> UNION ALL
> SELECT table1.id,
> table1.col1,
> CAST( NULL AS CHARACTER( 3 )),
> table3.type2
> FROM table1
> JOIN table3 ON table3.fk_table1 = table1.id;

Would the above changes work?

Regards,
Richard Broersma Jr.