นับตัวเลขในข้อความ หรือนับจำนวนข้อความที่มีตัวเลขปนอยู่ SQL SERVER

select count(id) as recCount from tbl where (fld like '[0-9]*' ) and (fld like '[a-zA-Z]*')

SELECT SUM(CASE WHEN SUBSTRING('LOVE_1_THAI_2_SEX', rn, 1) LIKE '[0-9a-zA-Z]' THEN 1 ELSE 0 END)            
FROM (SELECT rn = ROW_NUMBER() OVER (ORDER BY c1.type)            
      FROM master..spt_values c1) AS tmp            
      WHERE rn <= LEN('LOVE_1_THAI_2_SEX') 

SELECT LEN(REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE('abcdef12abcdef456'
, '0', '')
, '1', '')
, '2', '')
, '3', '')
, '4', '')
, '5', '')
, '6', '')
, '7', '')
, '8', '')
, '9', '')) AS countStr, 
LEN( 'abcdef12abcdef456') AS countAll

SET NOCOUNT ON;
DECLARE @pos int = 1
DECLARE @string char(9) = 'ABC012345';
DECLARE @varCountChr int = 0
DECLARE @varCountInt int = 0
DECLARE @varC1 char(1) = ''
DECLARE @Return BIT

WHILE @pos <= DATALENGTH(@string)
   BEGIN
   SELECT @varC1 = CHAR(ASCII(SUBSTRING(@string, @pos, 1)))
   IF @@ROWCOUNT > 0
      IF @varC1 >= 'A' AND @varC1 <= 'Z'
        SET @varCountChr = @varCountChr + 1
      ELSE
         IF @varC1 >= '0' AND @varC1 <= '9'
            SET @varCountInt = @varCountInt + 1
   SET @pos = @pos + 1    
   END;
IF @varCountChr + @varCountInt = 9
  SET @Return = 1
ELSE
  SET @Return = 0
SELECT @varCountChr, @varCountInt  
--RETURN @Return

CREATE FUNCTION CheckShegirlHeman(@Field VARCHAR(9))
RETURNS BIT
--WITH SCHEMABINDING
AS BEGIN
    RETURN @Return
END

int count = 0;
            string st = "Sawa1d1d3e Chaw Thaicreate M1Nivet Kub";
            foreach (char c in st)
            {
                if (char.IsNumber(c))
                {
                    count++;
                }
            }
            label5.Text = count.ToString();