I need a function where I can replace with String_split. I need that function without cross apply.
Because I am unable to use cross apply and string_split.

I have tried split(), split-part(), those are not working.

Cross apply string_split(isnull(effectivetime,”),’?’)b
This is a part of my query.Here I am unable to use cross apply and string_split function.