List:General Discussion« Previous MessageNext Message »
From:Gurhan Ozen Date:May 16 2002 8:54pm
Subject:RE: STRING TO NUMBER
View as plain text  
MySQL do it for you:)

Quoted from the online documentation is:
"
MySQL automatically converts numbers to strings as necessary, and
vice-versa:

mysql> SELECT 1+"1";
        -> 2
mysql> SELECT CONCAT(2,' test');
        -> '2 test'

If you want to convert a number to a string explicitly, pass it as the
argument to CONCAT().
"

See: http://mysql.com/doc/S/t/String_functions.html

Gurhan

-----Original Message-----
From: Marcel [mailto:tardelli_consult@stripped]
Sent: Thursday, May 16, 2002 3:27 PM
To: mysql@stripped
Subject: STRING TO NUMBER


Hi,
In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i
have to use in Mysql ??

thank´s

Marcel.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread109298@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-c-gurhan.ozen=wcom.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Thread
MessageAlexander Burbello16 May
  • MessageAlexander Burbello16 May
  • Re: MessageEgor Egorov16 May
    • Re: Messagemassey16 May
      • STRING TO NUMBERMarcel16 May
        • Re: STRING TO NUMBERAnil Garg16 May
        • RE: STRING TO NUMBERGurhan Ozen16 May