> 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.

What happens if you use DEC or DECIMAL?


=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod

Reply via email to