Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
You can use CAST function to convert a char data type to an integer, but the broekr will throw an exception if the char datatype contains non-numeric chars. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
Could you do it in some form of case statement?
outputvar = CASE inputvar WHEN 'a' THEN 1
WHEN 'b' THEN 2 etc.
or were you trying to convert an ascii char it to ascii value?
not sure about how to do that, short of writing a plugin or just using a really long case statement.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum