Convert to Hex


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Convert to Hex

Hybrid View

  1. #1
    Sarel j Smit Guest

    Convert to Hex


    If I do a query from SQL 7.0 and get the result "10" which is a hex value
    (0x0A), how do I convert this using something like convert or cast to show
    "a"
    Is there anywhere that I can look for help? I can get it to show 0x0A using
    cast, but that is not what I want. I want a hex number without 0X0 in front
    of A. The A I can convert using something like Lower(A)

    Thank you.

  2. #2
    Adelle Hartley Guest

    Re: Convert to Hex

    "Sarel j Smit" <ssmit@news24.co.za> wrote in message
    news:3b0cb305$1@news.devx.com...
    >
    > If I do a query from SQL 7.0 and get the result "10" which is a hex value
    > (0x0A), how do I convert this using something like convert or cast to show
    > "a"
    > Is there anywhere that I can look for help? I can get it to show 0x0A

    using
    > cast, but that is not what I want. I want a hex number without 0X0 in

    front
    > of A. The A I can convert using something like Lower(A)


    How about something like

    Lower(Right(Your_Cast_Expression,LEN(Your_Cast_Expression)-3)))

    Adelle.
    _____________________________________________________________
    Impress your friends. Become an SQL guru.
    http://www.sql-guru.com



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center