Community Patterns

Community Library Entry

1

Regular Expression
Created·2024-04-11 15:49
Flavor·PCRE2 (PHP)

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

Description

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

Submitted by Noel Cruz