ISNULL FUNCTION
I HAVE A PROBLEM WITH THIS CODE PAGE 195
SELECT cu.CompanyName,
ISNULL(CAST ((SELECT MIN(o.OrderDate)
FROM Orders o
WHERE o.CustomerID = cu.CustomerID)AS varchar), ' NEVER ORDERED')
AS "Order Date"
FROM Customers cu
i have i return: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'SELECT'.
|