I have the house numbers coming from the MSAccess text field.
(The database can be oracle, anyway)
In my vb6 code I have to assign the next house no.
A sample may be
I want to see the numeric part of each of these and find the highest and add 1
The requirment is to find the next house number to propose .(In this case it should be 201)