Implementing Scalar Function with COALESCE in TX Hi TX Support, I wanna know how to implementing scalar function with COALESCE in TX ? Here I attach the function, could you please tell me how to do that? USE [QAD_DATA]GO/****** Object: UserDefinedFunction [dbo].[GetAliasesByWo1] Script Date: 03/20/2018 16:15:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[GetAliasesByWo1](@item nvarchar(max),@length float,@catego nvarchar(max),@opt nvarchar(max))RETURNS varchar(max)ASBEGINdeclare @output varchar(max)select @output = COALESCE(@output + ', ', '') + wo_lot + '=' + convert(nvarchar, wo_qty_ord)FROM wo_mstr_datawhere wo_part = @item andwo__dec01 = @length andwo__chr01 = @catego andRIGHT(wo_rmks,1) = @opt andwo_status = 'R' andSUBSTRING(wo_routing,1,6) = 'REWORK' return @outputEND