How do I create an eval statement to combine similar fields?

[dbcase]

Hi,

If I have data that looks like this

abc
abc456
xyz
xyz456

How could I create an eval statement that says

if field1=abc or if field1=field1+456 then field1=field1?

Meaning, combine "abc" and "abc456", and combine "xyz" and "xyz456" together.

[dbcase · Accepted solution]

Solved it, used the like function

[dbcase]

A bit more info as I think I gave a poor example

abc can be 3 positions or it could be abcdef (more than 3 positions), however, 456 is always consistent