That did it!! Thanks
Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lawrence Lustig Sent: Wednesday, July 21, 2004 4:50 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: combining two text fields in a view problem > 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
