MySQL Forums
Forum List  »  General

Casting String to Integer
Posted by: Aunts S
Date: December 11, 2005 09:57AM


in the database there is a field ktnr as String, but ktnr should only be Integer!

if i create a new table with ktnr INTEGER and load the data, there will be a mistake, if ktnr includes not only integer values :-( For example: "123456e"

How can i solve the problem?

1. How can i convert String to Integer and conclude the exception cases into the query!?


2. How can i start the database (or write the query) such waz, that in exception case there won´t be a brealk!?


Options: ReplyQuote

Written By
Casting String to Integer
December 11, 2005 09:57AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.