≠ is part of the extended ascii character set as well as unicode, so theoretically it could be like this, but it's an unsupported syntax in any programming language....
It just doesn't work, see....
select * from einstein
where E ≠ MC2
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '≠'.
It's not according to ansi sql standard