Consulta Unicode con SQL Server

[portal47]

Código SQL:

SELECT CAST (Title AS NVARCHAR(200)) COLLATE SQL_Latin1_General_CP1_CI_AS Title, SubTitle, Initiators, 
WinningTypeID, WinningType, RewardTypeID, RewardType, WinningYear, ShortDescription, Initiators, 
Description, Image1, Image2, Image3, Image4, InitiatorEmail, InitiativeID, InMemoryOF 
FROM ViewWebWinningInitiatives
    WHERE RewardTypeID = 1
    AND WinningYear = '$_year'
    AND WinningTypeID = '$_type'
    AND Title LIKE '%$_input%'
    ORDER BY Title
 

Editado: Codigo de programacion no permitido en Foros de BBDD.
Leer las reglas del foro, por favor...