format expressions like operator
Would it be possible to treat the 'LIKE' operator the same as '=' in the Expressions\Operators settings so they are all aligned?
select AddressID
from Person.Address
where ModifiedDate
between dateadd(month, -6, getdate())
and getdate()
and City = 'Bothell'
or left(PostalCode, 2) like 'CB%'
or PostalCode = @prefix + @suffix
2
votes
Brad
shared this idea
-
Brad
commented
select~~AddressID
from~~~~Person.Address
where~~~ModifiedDate
between~dateadd(month,~-6,~getdate())
and~~~~~getdate()
and~~~~~City~~~~~~~~~~~~~~~~=~~~~'Bothell'
or~~~~~~left(PostalCode,~2)~like~'CB%'
or~~~~~~PostalCode~~~~~~~~~~=~~~~@prefix~+~@suffix