Re: Construct with varchar

In article <23tkh3INNlj5@emory.mathcs.emory.edu> trr@trac3000.ueci.com (Ted Reph) writes: >Machine Type: IBM RISC/6000 version 3 AIX >Informix Product: Rapid Development 4.00.UH1 > >(vendor_name field is of type VARCHAR) > >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*". > >Ted Reph @ UE&C - Catalytic in Philadelphia, PA This is known bug #8017; it was fixed in the 4.10 baseline. Any 4.1X.UXX release should take care of this one. -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "I got a new dog; he's a Paranoid Retreiver. He brings back everything, because he's not sure what I threw him." -- Steven Wright