I have the following statement in Visual Studio 2005 which is connected to SQL Server 2005. It complies without erros but displays the field FullName as Null. There is data. If I display the fields individually they show. What am I missing?
SELECT LastName + ', ' + FirstName + ' ' + MiddleName + ' ' + FileNo AS FullName