String to number conversion
"Dusan Kolesar" <[email protected]> Tue, 19 Jun 2007 14:40:58 +0200
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <op.tt55ikyiprzcvo@dusanxp> |
Hello, I want to convert Varchar ASCII column to Integer data type. When I'm using NUM () function and my string column contains characters that cannot be interpreted as a numeric value statement returns me an error. Is it possible to convert chracters to numbers, while entries that cannot be interpreted as a numeric values will be null ?? Thanks Dusan -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[email protected]