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 a

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