Home Forums SQL Server 2012 SQL 2012 - General Help me with the regular expression RE: Help me with the regular expression
drew.allen
SSC Guru
Points: 76931
More actions
February 28, 2018 at 12:28 pm
#1981533
declare @SearchVal varchar(10) = '1234.00'
select 'yes'where @SearchVal NOT LIKE '%[^0-9.]%' AND @SearchVal NOT LIKE '%.%.%'
Drew
J. Drew AllenBusiness Intelligence AnalystPhiladelphia, PA