I'd like to know how best to write some SQL that allows me to select a portion or portions of a character string with pipe separators. For example, the string could look like:
"Name|Address|Telephone Number|email address"
So I would like to able to say something like:
select "portion 3 from character string"
from "table name"
where "field name" is not null (--this is a constant field name where the data is stored)
Any help most welcome