hello , please i have a question a want to convert a special caractere so i can split it after that but my special caractere is like this
OBAFRAISOBAFRAIS-TAX

here is the code that i used
select id , value from [dbo].[Details] cross apply string_split(Replace(cast(property as nvarchar(max)),'?',';'),';')