petronas40 (10/22/2013)
I have to extract the record which has 6 numbers which are together from the string .Customer ID Address
6237 025 OHIO DR APT 13111
9261 123 main street #1567
8036 12 lee street #8956345
I need to choose Customer Id = 8036.
You could use REPLACE to make all the numbers (somewhat deliberately) run together in the first part of you query and then do pattern matching
LIKE [0-9][0-9][0-9][0-9][0-9][0-9][A-Z]%
not totally sure about the last part. (the "not a number")