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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
