I have a column VarChar(15) that I need to find the highest value in. It's a part # and I need to add a 1 to the existing part #.

ALL-15, FLR-142A, MAK-97W, ZR-5

I could cheat in VFP with a VAL(). How can I pull this out in a Select Statment?

TIA

__Stephen