[RBG7-L] - Re: How to force a text expression to be type TEXT in a view

[Lawrence Lustig]

> CREATE VIEW LarrysView +
> (PartInfo) +
> AS +
> SELECT Sys_Table_Name FROM Sys_Tables +
>   WHERE SYS_TABLE_ID = -10 +
> UNION ALL SELECT +
> (PartID + '-' + PartCode) +
> FROM LarrysTable 

Very clever, Mr. Bond.
--
Larry