SqlServer扩展ISNULL 空字符与NULL设置默认值

ALTER FUNCTION [dbo].[IsNullOrTrimEmpty]
(
    @check_expression  NVARCHAR(1000),
    @replacement_value NVARCHAR(1000)
)
RETURNS NVARCHAR(1000)
AS
BEGIN

    RETURN CASE
               WHEN TRIM(ISNULL(@check_expression, @replacement_value)) = '' THEN
                   @replacement_value
               ELSE
                   ISNULL(@check_expression, @replacement_value)
           END;

END;