To handle NULL values, the SQL Coalesce and IsNull methods are utilized. The NULL values are substituted with the user-defined value throughout the expression evaluation process. The SQL Coalesce function evaluates the arguments in the specified order and always returns the first non-null value from the parameter list.