Find recent users by location

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results