0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

declare @y table (y nvarchar(100), y2 nvarchar(100))

insert @y values ('%Россия%', 'Russia')
insert @y values ('%United States%', 'United States')

select TOP 1000 *
FROM Users U
INNER JOIN  @y  y On U.Location LIKE y.y COLLATE SQL_Latin1_General_CP1_CS_AS

fork query

edited feb 17 18

created feb 16 18 anonymous