For whatever reason, the Microsoft operator functions are case-sensitive, so you
need to be very careful when you type out the query. There's a possibility that
ArcSDE will UPCASE your query, in which case, you'll need to change the WHERE
clause to something mundane ("1=1") then edit the view later. You should
certainly prototype your query within SQL-Server tools, then once it's working,
paste it into the "Create View" window.
- V