DB fields with composite data

[maw]

Hello,

We have to maintain a database where some of the fields have composite values. for example, field SECFLAGS is a character 10 field and has a value of 'YYYNYYNNNY'. We obviously don't want to display that to the administror user, so we need to split it up into 10 boolean (or something) fields. Any recommendations on how to do this, or the general strategies?

Thanks in advance, Mark.

[Isomorphic]

You haven't indicated what general data integration strategy you are using (e.g. SQLDataSource vs Hibernate va custom), but for example with SQLDataSource, you could use a customSelectExpression to extract each flag into its own Boolean field.