String search in large table [message #21351] |
Sat, 27 July 2002 11:25 |
Tracy Veara
Messages: 2 Registered: July 2002
|
Junior Member |
|
|
Hi guys,
I appreciate any help you can give me here.
My supervisor has asked me to query a very large (several million rows) table for some specific information. I am to return all records in the table where any values in the SEC_ID column contain three or more repeating characters. I need to be able to search for ANY alphanumeric or special characters at any location in the string. Obviously the workaround is to specify criteria for every possible combination of three characters available on a standard keyboard, but I really want to stretch my skills by learning to do this programmatically. Can anyone assist me? Thanks.
Regards,
Tracy Veara
|
|
|
|