Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more
-- SearchLocation must appear at hte beginning or end of the listed location select Id as [User Link], * from users where (lower(left(Location, len(##SearchLocation:string##))) = lower(##SearchLocation:string##) or lower(right(Location, len(##SearchLocation:string##))) = lower(##SearchLocation:string##)) --and DateDiff(day, LastAccessDate, getdate()) <= 30