Or do it in the query ... Oracle would be something like ...
SELECT substr(your_column_here, 1, 1) AS COL1, substr(your_column_here, 2, 1) AS COL2, substr(your_column_here, 3, 1) AS COL3, .... substr(your_column_here, 11, 1) AS COL11 FROM your_table_here Not that I am recommending it ... I'm just offering it as an alternative. Cheers Glen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---