split and reverse a string in a field

[mzeltman]

I have a table that contains a field called "ancestry". The records in this field contains IDs separated by a "/". For example:

34/56/132/144/412/1243

I want to be able to split this string, reverse it, and then be able to test each value within the string. So, from the example above, I want to end up the following:

1234/412/144/132/56/34



where I can loop a test of the values...first against 1234, then 412, then 144 and so on.

Any suggestions?

[ItsMe]

The code I use to do stuff like that is rather complex. I don't know if others have a simple solution.