Consulta Unicode con SQL Server

[gnzsoloyo]

Sería... Aunque le falta el alias para la tabla derivada.

Código SQL:

SELECT * 
FROM (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') Tabla
WHERE Title LIKE '%$_input%'
ORDER BY Title
 

¿Lo probaste?