I have read the cross apply articles

I made the following code to see if I understand it correctly.

SELECT 'D' AS RECORDTYPECODE

, a.[Id]

,a.[FundsMovementItemTypeId]

,a.[FundsMovementSetId]

,a.[FeeTypeId]

,AccountName = iTVF.result

,GLAccountName = iTVF1.result

,LodgementReference = iTVF2.result

,AccountNumber =...

Thanks a lot for your reply!

Can you please guide me how to call a iTVF function

in the Select SQL I posted? Same syntax or I need

to use Cross Apply?

I don't...

I have written another UDF to use while loop shown as below:

create function dbo.[ReplaceSplVarcharsBICD_test3] (@s varchar(8000)) returns varchar(8000)

with schemabinding

begin

if @s-2 is null

...