When the following field

FULLCAPTION Computed by: ((
 with recursive
  Hospitals_Recursive as (
   Select H.HospitalID, H.HospitalParentID, H.Caption,
    1 as ChildLevel
   From Hospitals H
   Where H.HospitalID = Hospitals.HospitalID

   union all

   Select H.HospitalID, H.HospitalParentID, H.Caption,
    Hr.ChildLevel + 1 as ChildLevel
   From Hospitals_Recursive HR inner join Hospitals H
    on HR.HospitalParentID = H.HospitalID
  ),
  Hospitals_List as (
   Select Caption
   From Hospitals_Recursive
   Order by ChildLevel desc
  )
 Select list(Caption, ', ')
 From Hospitals_List
))

is used in a query:

select HospitalID, FullCaption From Hospitals
Order by cast(FullCaption as varchar(32765));

access violation happens.