Kenneth_Elder28
Member
Has anyone used SUBSTR succesfully in ER. I am trying to substring out the
first 5 characters of Tax Rate/Area in program P4210 and I CANNOT get it to
pick up the first character. I have tried the following statements and
neither work.
FC Tax Rate/Area = substr([FC Tax Rate/Area],0,5 )
and
FC Tax Rate/Area = substr([FC Tax Rate/Area],1,5 )
Any help would be appreaciated. Thanks.
______________________
Kenneth Elder
Lead Analyst
Hartmann, Inc.
Phone: (615)453-3220
Fax: (615)443-4619
NT 4.0 SP5, One World 7332, SP11.3, SQL 7.0 SP2, MDAC 2.5
first 5 characters of Tax Rate/Area in program P4210 and I CANNOT get it to
pick up the first character. I have tried the following statements and
neither work.
FC Tax Rate/Area = substr([FC Tax Rate/Area],0,5 )
and
FC Tax Rate/Area = substr([FC Tax Rate/Area],1,5 )
Any help would be appreaciated. Thanks.
______________________
Kenneth Elder
Lead Analyst
Hartmann, Inc.
Phone: (615)453-3220
Fax: (615)443-4619
NT 4.0 SP5, One World 7332, SP11.3, SQL 7.0 SP2, MDAC 2.5