SQL Views And Testing For Nulls

Pop quiz hotshots:





I am creating a View in SQL2000 where i concatenate values from multiple tables. My problem is that if one of the values is null then the whole string is null, so I would like to know how to test for nulls within the Select part if the View.





Select


Titles.Title + ' ' + User.Forename + ' ' + User.Surname AS FullName,








For example;


If User.Forename is null, I still want to return Titles.Title and User.Surname as a concatenated string.





I’ve tried I few things like places if statements within the Select part but I can’t get it to work.





Many thanks