I misunderstood the OP and updated my function to do what I think you are trying to do (it was originally searching for an id instead of six consecutive integers. What I am still not clear about is if this:
Customer ID Address
6237 025 OHIO DR APT 13111
9261 123 main street #1567
8036 12 lee street #8956345
Represents a table or a string. If it represents a table then Sean understood your requirement correctly and you just need to return records from a column that contain 6 consecutive numbers then what Sean posted is exactly what you need. If Sean was mistaken and you are looking for to extract that information from a string then the function I posted will give you what you want. In my previous post I demonstrated how pull this information from a variable or parameter. Below is how you would do it if the information was in a table...
-- getting this information from a variable or parameter
DECLARE @string varchar(200)=
'Customer ID Address
6237 025 OHIO DR APT 13111
9261 123 main street #1567
8036 12 lee street #8956345';
SELECT *
FROM dbo.string_to_table(@string)
WHERE customer_address LIKE N'%[0-9][0-9][0-9][0-9][0-9][0-9]%'
-- getting this information from a table
;WITH customer_import_data(id, cust_data) AS
(SELECT 1,
'Customer ID Address
6237 025 OHIO DR APT 13111
9261 123 main street #1567
8036 12 lee street #8956345'
UNION
SELECT 2,
'Customer ID Address
5537 333 DELEWARE APT 222
6133 888 main street #2
5555 55 hee Ave #44558899'
)
SELECT customer_id, customer_address
FROM customer_import_data cd
CROSS APPLY dbo.string_to_table(cd.cust_data) sp
WHERE customer_address LIKE N'%[0-9][0-9][0-9][0-9][0-9][0-9]%'
-- Itzik Ben-Gan 2001