Compare records from a field

[olguita2014]

Hi,

Please I need your help!!!!!

I want to compare records from a field.  For example:

122

123

1231

1232

1233

1234

In this example, the number 123 exists in the other registers, but 122 does not exist.

Thanks

[Anonymous]

Are you specifically looking for "123"? what are you trying to do e.g. trying to find all numbers starting 123...

[olguita2014]

Take the length of the number equal to 3, then compare that with all other records if there is a relationship.

1234

1235

1236

1237

122

The Answer:  123 yes it exists in the comparison but 122 no