IfBlank function for SQL Server

IfBlank.sql

-- =============================================
-- Author: Zonaro
-- Create date: 30/03/2023
-- Description:	Return a replacement value if expression is null or contains only whitespace
-- =============================================
CREATE FUNCTION IfBlank
(
	@expression varchar(max),
	@replacement varchar(max)
)
RETURNS varchar(max)
AS
BEGIN 
	RETURN isnull(nullif(ltrim(rtrim(@expression)),''),@replacement)
END
GO