In SQL Server, you can use ISNULL(exp1, exp2) function. Oracle Example: -- Return 'N/A' if name is NULL SELECT NVL(name, 'N/A') FROM countries;
確定! 回上一頁