string_split

declare @var varchar(100) = 'betül tabak'

select
  n.r.value('.', 'varchar(50)')
from (select cast('<r>'+replace(@var, ' ', '</r><r>')+'</r>' as xml)) as s(XMLCol)
  cross apply s.XMLCol.nodes('r') as n(r)