STRING_SPLIT equivalent in Cache SQL
I'm looking for a SQL function equivalent for SQL server STRING_SPLIT. I have records like this:
join_to_tx_history (key), ss_note_multi_dict_1_value (varchar)
64559.001 | Assistant Principal, Case Worker, Client, Dad, Daughter, Mentor, Mom, Other, Principal, Psychiatrist, School Counselor, Teacher |
and I like the field ss_note_multi_dict_1_value split to rows for each comma delimited value. So I can get this:
64559.001 Assistant Principal
64559.001 Case Worker
64559.001 Client
64559.001 Dad
64559.001 Daughter
64559.001 Mentor
64559.001 Mom
64559.001 Other
64559.001 Principal
64559.001 Psychiatrist
64559.001 School Counselor
64559.001 Teacher
Any ideas in Cache SQL?
Product version: Caché 2017.1