sql server - How to match '0', '00', '000', '0000' ... pattern in TSQL? -
what statement can utilize instead of below query?
select * customer.dbo.human ltrim(rtrim(mobile)) in ('0', '00', '000', '0000', ....)
assuming want match mobile numbers consist exclusively of zeroes , spaces , contain @ to the lowest degree 1 zero.
then next 1 way..
where mobile '%0%' , mobile not '%[^ 0]%' sql-server tsql like
No comments:
Post a Comment