Construct with varchar

Machine Type: IBM RISC/6000 version 3 AIX Informix Product: Rapid Development 4.00.UH1 I N F O F O R T A B L E vn_mast_760 Column name Type Nulls vn_id serial no vendor_cde char(8) yes vendor_name varchar(30,0) yes FORM DATABASE tracsy SCREEN { --inmnm10---------------------------------- Item Manufacturer Maintenance ----- Contract Number [f000 ] Vendor Code [f002 |f003 ] } TABLES vn_mast_760, systables ATTRIBUTES f000 = FORMONLY.gv_cnt_nbr, DISPLAY LIKE systables.tabid; f002 = vn_mast_760.vendor_cde, AUTONEXT, COMMENTS="Enter the vendor code.", DISPLAY LIKE systables.tabid, UPSHIFT; f003 = vn_mast_760.vendor_name, AUTONEXT, COMMENTS="Enter the vendor name.", UPSHIFT, DISPLAY LIKE systables.tabid; END CONSTRUCT BY NAME b_txt ON vn_mast_760.vendor_cde, vn_mast_760.vendor_name My problem is that when I do the construct on vendor_name with "A*", the construct returns b_txt with vn_mast_760.vendor_name="A*" instead of vn_mast_760.vendor_name MATCHES "A*". It is interesting to note that when the form is changed to the following: f003 = FORMONLY.vendor_name, the construct statement returns vn_mast_760.vendor_name MATCHES "A*". It appears to me that informix has a bug (or a unique feature) or I did not RTFM. Note: If I put "A*" in vn_mast_760.vendor_cde, the construct statement returns a value of vn_mast_760.vendor_cde MATCHES "A*". -- Ted Reph @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!trr INTERNET: trr@trac2000.ueci.com