How to detect if a string contains at least a number? February 8, 2023 by Tarik Use this: SELECT * FROM Table WHERE Column LIKE '%[0-9]%' MSDN – LIKE (Transact-SQL)