Hello.
Possible solution is to use REGEXP:
mysql> select '911' regexp '^[1-9]*$';
+-------------------------+
| '911' regexp '^[1-9]*$' |
+-------------------------+
| 1 |
+-------------------------+
mysql> select '91a1' regexp '^[1-9]*$';
+--------------------------+
| '91a1' regexp '^[1-9]*$' |
+--------------------------+
| 0 |
+--------------------------+
"C.R.Vegelin" <[EMAIL PROTECTED]> wrote:
>Hi everybody,
>I looked for a function to test whether a string is numeric (having characters
>0..9 only).
>I found in the 5.0 manual Cast() and Convert(), but I don't think these do
>what I need.
>Any suggestion what function to use ?
>Thanks in advance, Cor
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
