I have to change or update a field that may have up to 30 different text
values on a daily basis from an imported file.

The the list of new values are always consistant.

eg.  ABC1  needs to be just shown as 1 not ABC1
     ABC2  needs to be just shown as 2  not ABC2

There may be up to thirty variations and need to do this with one click of a
button somehow, or should I look at some kind of grid or lookup of some sort
on a batch routine.

How do you think this could b best handled.

John


Something like

UPDATE tble SET fld = SUBSTR(fld,4,1) WHERE LENGTH(fld) = 4

Roy Lambert

Roy,

You lost your [Team Elevate] tag.  You didn't quit, did you ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>You lost your [Team Elevate] tag. You didn't quit, did you ?

Nah - the electron eater got it

Roy Lambert [Still Team Elevate]