Q&A for designers and implementers of computer programming languages
DECLARE @location AS nvarchar(max) = ##location:string##; SELECT u.DisplayName,u.WebSiteUrl,u.UpVotes,u.AboutMe FROM Users u WHERE lower(u.Location) LIKE lower('%' + @location + '%')