October 24, 2007, 01:58 PM
<Umar Farook S>CHAR to ALPHANUMERIC
Hi
I like to know how can i convert a CHAR field to AlphaNumeric field or VarChar field.
October 24, 2007, 02:10 PM
Darin Leea CHAR field IS an alphanumeric. CHAR(10) = A10, VARCHAR(10) = A10V
October 24, 2007, 02:31 PM
LeahAs to converting, you can use a define or a compute. As Darin says they are alphanumeric.
October 24, 2007, 02:34 PM
<Umar Farook S>So i am in the process of doing MATCH between 2 HOLD files with key fields in one file having CHAR and in another file having AplhaNumeric formats.
October 24, 2007, 06:52 PM
GinnyJakesI think the answer has already been given. Use a DEFINE and set up an equality to convert what I think you are calling alphanumeric but really mean varchar (that's the format with the V that Darin refers to) to a char, i.e. something without the V or vice versa.
FLD_C/A10='1234567890';
FLD_V/A10V=FLD_C;