Since everything is being brought in as a VARCHAR, is there any reason you
cannot use the .startsWith(") method from the String class?

String.startsWith() may execute faster than Integer.parseInt() (or so I assume - logically at least, this seems probable), but I think the Interger.parseInt() method is probably the best one to use. As the data value in the varchar column can potentially be made up on 16 characters - and any of those characters may be the non-numeric character.

Thanks for the suggestion Annetta.



Reply via email to