I have a column containing multiple data values separated by a pipe delimiter. I know the number of values packed in the column. Is it possible to write a SQL query to extract the individual values?

For example.

Transaction Details (single column)

===============

SUCS|$50|SALE|REF10291

We have a single column containing 4 pieces of information. Using SQL (or may be a column formula?) I would like to extract the four pieces of information as separate columns i.e.

TransStatus, TransValue, TransType, TransReference

SUCS, $50, SALE, REF10291

Do you have a clever way of doing this?

Thanks

Sunil