No the concatenation becomes this :

SELECT * FROM [Login] where [User] = 'Ninja''s_RGR''us';