Hi,
There is a table containing Null values. I am doing the following Select Query:
SELECT Project_ID + ' ' + Task + ' ' + Sub_Task + ' ' + Proj_Desc As Project
FROM dbo.TMS_Proj
Order By Project_ID
Needless to say the query results do not return rows where there exist a null value. I want ALL of the rows returned and am not certain how this is done. Any help is greatly appreciated.
Thanks,
JohnShell