SET @SQLStmt = 'SELECT TOP 100
M.AuthNumber, 
M.CallDate, 
M.ModelDescription, 						   
C.CustomerForename + '' '' + C.CustomerSurname As CustomerName, 
CASE WHEN C.CustomerStreet = '' THEN
C.CustomerVisitingStreet, C.CustomerVisitingPostcode + '' '' + C.CustomerVisitingTown
ELSE
C.CustomerStreet, C.CustomerPostcode + '' '' + C.CustomerTown 
END As CustomerPostcode,						   
CASE WHEN Status = 0 THEN ''Open'' ELSE ''Closed'' END As Status, 
ISNULL(E.Name,''-'') As Engineer, 
CASE WHEN RouteStatus = 0 THEN ''Not Assigned''
WHEN RouteStatus = 1 THEN ''Awaiting Part'' 
ELSE ''Assigned'' 
END As RouteStatus  
FROM dbo.tbl_Call_Record_Main M 
INNER JOIN dbo.tbl_Call_Record_Customers C ON C.AuthNumber = M.AuthNumber 
LEFT JOIN dbo.tbl_Engineers E ON M.EngineerID = E.EngineerID
WHERE ' + @SearchTerms + ' 
ORDER BY M.CallDate DESC '

SET @SQLStmt = 'SELECT TOP 100 
   M.AuthNumber, 
   M.CallDate, 
   M.ModelDescription, 						   
   C.CustomerForename + '' '' + C.CustomerSurname As CustomerName, 
			   
   CASE WHEN C.CustomerStreet = '' THEN C.CustomerVisitingStreet ELSE C.CustomerStreet END AS CustomerStreet, 
   CASE WHEN C.CustomerPostcode = '' THEN C.CustomerVisitingPostcode + '' '' + C.CustomerVisitingTown
   ELSE C.CustomerPostcode + '' '' + C.CustomerTown END As CustomerPostCode,						   
						   
   CASE WHEN Status = 0 THEN ''Open'' ELSE ''Closed'' END As Status, 
   ISNULL(E.Name,''-'') As Engineer, 
   CASE WHEN RouteStatus = 0 THEN ''Not Assigned''
   WHEN RouteStatus = 1 THEN ''Awaiting Part'' 
   ELSE ''Assigned'' 
   END As RouteStatus  
   FROM dbo.tbl_Call_Record_Main M 
   INNER JOIN dbo.tbl_Call_Record_Customers C ON C.AuthNumber = M.AuthNumber 
   LEFT JOIN dbo.tbl_Engineers E ON M.EngineerID = E.EngineerID
   WHERE ' + @SearchTerms + ' 
   ORDER BY M.CallDate DESC '

EXEC(@SQLStmt)