Creation of view with case when statement...

How can I pull records from several different tables into a single view in SQL Server 2008 R2?...

BLOB in MySQL view instead of the proper data...