CREATE TABLE #TableA ( id INT,columnA VARCHAR(200))
INSERT INTO #TableA
	SELECT 1,'here is my phone number 12345678. but my cell is 44444444.' UNION ALL
	SELECT 2,'987654321 is my balance' UNION ALL
	SELECT 3,'i like the number 55555555. it is cool' UNION ALL
	SELECT 4,'66666666'

SELECT id, MIN(PATINDEX(n,columnA)) AS pos
FROM #TableA
CROSS APPLY
(
	SELECT '%4444%' AS n UNION ALL 
	SELECT '%123%'
)sub
GROUP BY id
DROP TABLE #TableA

DECLARE @Table
TABLE   (
        id      INTEGER IDENTITY PRIMARY KEY,
        data    VARCHAR(200) NOT NULL
        );
        
INSERT  @Table (data)
SELECT  'here is my phone number 12345678. but my cell is 44444444.' UNION ALL
SELECT  '987651234 is my balance' UNION ALL
SELECT  'i like the number 4444444. it is cool' UNION ALL
SELECT  '66666666';

SELECT  id,
        pos =
            (
            -- Find the lowest of the positions found
            SELECT  MIN(Positions.pos)
            FROM    (
                    -- Try to find both patterns
                    SELECT  pos = CHARINDEX('4444', T.data)
                    UNION   ALL 
                    SELECT  pos = CHARINDEX('1234', T.data)
                    ) Positions
            -- Exclude cases where no match ws found
            WHERE   Positions.pos > 0
            )
FROM    @Table T;

DECLARE @String VARCHAR(300);

SET     @String = 
            'here is my phone number 1234567890. but my cell is 4444444444, ' +
            'and my work number is 5555555555. i said my my phone number 1234567890. ' +
            'and my cell is 4444444444, and my work number is 5555555555.';

WITH    Numbers (n)
AS      (
        -- Numbers 1...length of string
        SELECT  TOP (DATALENGTH(@String))
                ROW_NUMBER() OVER(
                    ORDER BY (SELECT 0))
        FROM    master.sys.columns C1,
                master.sys.columns C2,
                master.sys.columns C3
        )
SELECT  @String = STUFF(@String, N.n + 4, 6, REPLICATE('X', 6))
FROM    Numbers N
WHERE   SUBSTRING(@String, N.n, 10) LIKE '4444[0-9][0-9][0-9][0-9][0-9][0-9]'
OR      SUBSTRING(@String, N.n, 10) LIKE '1234[0-9][0-9][0-9][0-9][0-9][0-9]';

SELECT  @String;