Thu Feb 23 14:48:40 EST 2012

Expanding text field into table using regular expressions

I have a table with a text field that has data in it that I want to
extract into table.  I.e. suppose the text field has 'AA:BB:CC' then I
want to separate this out into 3 fields 'AA','BB',CC'.

The way to do this is something like:

   SELECT fn(column) where ...;

where the fn is a function that parses the string.