Subject Re: Composite vs single column keys
Author sboydlns
> alter table gl add concat_key computed by (company || account || division ||
> department);
>
> create asc index ix_gl_concat on gl computed by (company || account || division
> || department);
>
> select * from gl where concat_key > ('CO' || 'ACCT');
>

I thought about something like that but these are all Varchar fields, so concatenating them together isn't going to work. I suppose that they could be changed to Char. I will have to play around with it to see if that will do what I want.