Sybase Split Data on Delimeter

Question

I have a column which stores data as

"George|Michael|15-06-1984|New York"

Expected Output is

FIRST_NAME LAST_NAME DOB        CITY
George     Michael   15-06-1984 NEW YORK

How to split this data on delimiter - | while calling a select query in Sybase ?

Answer 1

You can make a procedure:

Here is a good solution:

sa_split_list system procedure replacement

Or you can use function called ParseName:

ParseName

Of course, you have to change your delimeter in select statement from , to |.