regex - TSQL pattern or reg expression to ensure all rows returned for varchar column are strictly alphanumeric -
i have researched this, obvious answer on stackoverflow converse question, , can't quite match situation.
i need tsql reg expression ensure rows returned particular varchar column(denoted col1 here) strictly alphanumeric (that is, row 1 non-alphanumeric char excluded)
something
where col1 'regexpgoeshere'
where value not match string containing not letter or number:
where f not '%[^a-z0-9]%'
(these patterns, not regular expressions)
Comments
Post a Comment