Hi,
I want to calculate a new field I added to a table but I'm not sure
how to do it. This will be a copy of another field with any non
numeric characters stripped off the end and padded with spaces.
This is what I was trying to do
Update Buildings SET B_LOT_SORT=lpad(substr(lot,1,??),7)
instead of ?? I need to know the position of the last numeric character.
Any suggestions would be appreciated
Christine Penner
Ingenious Software
250-352-9495
christine(at)ingenioussoftware(dot)com