if DB2 for non-OS/390, try ASCII(col) if DB2 for OS/390 V6, you'll have to use a UDF
James > > From: [EMAIL PROTECTED] > Subject: Thanks, and one more question... > Date: Fri, 2 Nov 2001 09:06:33 -0600 > MIME-Version: 1.0 > Content-Type: text/plain; charset=us-ascii > Content-Disposition: inline > > > > Hello again, > > Thanks to all who responded to my somewhat embarrassing question about how to > return current date in an SQL statement! I'm going to chalk that one up to > being up all night! > > OK, one more question and then I will quit bothering you folks! Now I have a > column in a table that is a character data type with a length of 1. I believe > what is stored in there is possibly like a bitmap or something. Anyway, I can > wrap the HEX function around the field and it returns the value as 1F, for > instance. If I use the CHAR function, it returns x'1F'. I am trying to convert > this to decimal, but I don't seem to have found the right mojo to get it to > convert properly. > > Any suggestions would be most appreciated! > > Thanks, > Judy > James A Campbell ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
