← Customer Feedback for Redgate Settings and activity 1 result found format expressions like operator 2 votes Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close Vote We’ll send you updates on this idea 1 comment · SQL Prompt » Format SQL · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close An error occurred while saving the comment Brad commented · May 2, 2019 · Edit… · Delete… 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 Save Submitting... Brad shared this idea · May 2, 2019
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