MySQL Forums
Forum List  »  General

Re: Convert string into a number
Posted by: Geoffrey Brier
Date: October 18, 2010 01:56AM

Just for my own culture, some kind of personal challenge I would say!
Thanks for your replies I will try it later.
Edit:
I reformulate my question, maybe you will see more what I'm trying to do
For example :
SELECT HEX('jkl')
-> 6A6B6C

How can I split the number '6A6B6C' into 6 then '6A' then '6A6' and so on (always using mathematical functions)?



Edited 1 time(s). Last edit at 10/18/2010 06:47AM by Geoffrey Brier.

Options: ReplyQuote


Subject
Written By
Posted
October 17, 2010 03:36PM
October 17, 2010 11:18PM
Re: Convert string into a number
October 18, 2010 01:56AM
October 18, 2010 07:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.