1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited apr 23 15

created nov 2 14 Isaac Moses