Data, Data Analysis, Data Engineering, Sql.
expression is NULL, otherwise, it returns the expression itself. Example: SELECT ISNULL(sales_amount, 0) AS amount_with_default FROM sales_data; Result: This query will return 0 for rows where sales_amount is NULL and the actual sales_amount for other rows. 4. INITCAP The INITCAP function