STRING TO NUMBER

2002-05-16 Thread Marcel 

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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: STRING TO NUMBER

2002-05-16 Thread Anil Garg 

i think u dont need to it will automatically deal with it.

- Original Message -
From: Marcel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 16, 2002 3:26 PM
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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: STRING TO NUMBER

2002-05-16 Thread Gurhan Ozen 

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:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 3:27 PM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php