Insanely easy points out there for you T-SQL jockeys...
I have a view which I am implementing, and the CREATE VIEW statement works exactly as expected.
Before running the CREATE VIEW statement, I want to check for existence of that same view, and if it exists, to drop the view. So, the logic looks like this:
IF EXISTS (statement to find the view) DROP VIEW dbo.MyView
CREATE VIEW dbo.MyView AS <SQL statement>
What I do not have is the "statement to find the view" bit :)