Regular Expressions 101

Community Patterns

IsNumeric Test

1

Regular Expression
PCRE2 (PHP >=7.3)

/
(?<IsNumeric>^[+-]?([1-9]*|[1-9]{1,3}(,\d{3})*|[0]*)(\.\d+)?)\b$
/
gm

Description

Tests for any value that can be converted to a T-SQL numeric type.

Submitted by Noel Cruz - 19 days ago