>What I need to do is create a view that contains a name field. If the Full Name doesn't exists, I want to combine the rest of the fields to return a full name. If the last names are the same, I want to return JOHN AND SALLY SMITH. If the last names are not the same, I want to return PAYTON MANNING / MARVIN HARRISON.

Mike,

Perhaps something like this would work:

SELECT ISNULL(FullName, 
              Name1First + ' ' +
                 (CASE WHEN Name1Last=Name2Last THEN 
                            'AND ' + Name2First
                       ELSE Name1Last + ' / ' + Name2First + ' '
                  END) + Name2Last) AS NewFullName

Laterness,
Jon

P.S. I just realized this was in the .Net forum. My response was based on T-SQL syntax for SQL Server.