RE: Generate data in Forms

If I understand you correctly you have to do this in a perform screen only... Perhaps you could accomplish this with a view The following works on my version (7.31) create view test(field12) asselect field2 || field1[5,7] from table HTH -----Original Message----- From: NDSTURNERBUND@t-online.de (Dirk Emmermacher) [mailto:NDSTURNERBUND@t-online.de] Sent: Wednesday, April 26, 2000 4:50 AM Posted To: informix Conversation: Generate data in Forms Subject: Generate data in Forms Hello list! I've got oonly a small problem. I try to get data from 2 fields in another field. Field 1 contains the value "0101001" Field 2 contains the value "0811" I want to get data from fiels 2 and the last three characters from field 1. The data in field should have the value "0811001". I'm using isql on a 4.00.UH2 standard engine. Is there a chance to get these data?? Thanx in advance. Dirk Emmermacher Lowersaxony gymnastics federation