S
sandhu
I have a table with the field name phone numbers
it looks like this
phone num
0408212630
0205101833
0609113234
1415162531
0308212630
above you can see that record no 1 and record 5 have 4
same numbers(08 21 26 30)
the output required is
0408212630
0308212630
there are thousands of records and there are many records
with the same numbers. Some have first 4 nos same, last
nos same, middle nos same, first and last 3 nos same etc.
What I would like to know is that how can I get these
records with the same 3 or more numbers reappearing in
other records in the table and there is only one field in
the table. And I am compairing one record with the other.
I would really appreciate for your help.
thank you.
..
it looks like this
phone num
0408212630
0205101833
0609113234
1415162531
0308212630
above you can see that record no 1 and record 5 have 4
same numbers(08 21 26 30)
the output required is
0408212630
0308212630
there are thousands of records and there are many records
with the same numbers. Some have first 4 nos same, last
nos same, middle nos same, first and last 3 nos same etc.
What I would like to know is that how can I get these
records with the same 3 or more numbers reappearing in
other records in the table and there is only one field in
the table. And I am compairing one record with the other.
I would really appreciate for your help.
thank you.
..