> I sort of got it to work but it cuts off my combined > field. In the example given, Bill used the SYS_TABLE_NAME column to "set" the type for the column. Since that column is defined as TEXT(18), 18 characters is what you get.
To get another length, define a table with a column of the appropriate length, and use that table in place of the SYS_TABLE reference in the first table in the SELECT UNION. -- Larry
