automating process?

[shannon]

I have a lot of records in a table named in this pattern "this text is the same.r01 someText (001/100)", "this text is the same.r01 someText (002/100)", "this text is the same.r02 someText (003/100)" etc.

i wish to automate the process of recognizing the files belonging to the same file, and then set a value which shows that is belongs to a certain fileID in another table. Any ideas of how to do this? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

My suggestion is :

... WHERE acol LIKE 'some literal text%' -- no leading % in the literal

with an index on acol, it can be quite fast -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --