Workaround 2 - change Unicode columns into ASCII

Use the PI SQL View for Attribute2 that was created earlier and make the comparison with the AnsiString column.

SELECT e."Name" Element, ea."Name" Attribute,
ea."Value"
FROM Element.Element@pi e
INNER JOIN Element.Attribute2@pi ea ON ea."ElementID" = e.ID
WHERE ea."Name" = 'Plant'
AND ea."Value_String" Like N'H%'
ORDER BY e."Name", ea."Name";