How to check numeric or alphabet value in column

Опубликовано: 12 Май 2026
на канале: Raptor Analytics

3,072

SQL Interview question and answer:

How to check numeric or alphabet value in column.

Query:
-- Get details of table
SELECT *
FROM test

-- Get only numeric value
SELECT Value
FROM Test
WHERE ISNUMERIC(Value) = 1

-- Get only alphabet
SELECT *
FROM test
WHERE Value NOT LIKE '%[0-9]%'

-- Get alpha-numeric
SELECT *
FROM test
WHERE Value LIKE '%[0-9]%'
AND ISNUMERIC(Value) = 0