The 'funny' thing is that although Query Designer doesn't parse it, it is allowed in a View.
So, what I tend to do as a work around, is one of these 2 things:
1. Use a script to create your view, as shown in books online:
USE pubs
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'titles_view')
DROP VIEW titles_view
GO
CREATE VIEW titles_view
AS
SELECT title, type, price, pubdate
FROM titles
GO
2. Create and test the view in Query Analyser, then create a View in Enterprise Manager by adding in a simple table and selecting a field. Save it, open it up and paste the query into it (from SELECT down of course).