Re: Index on partial field?

Barbara Hiles wrote:
>
> Is it possible to create an index using part of a field?
> For example: 9 character ssn.
> I need an index on last 4 first 5.
> Can I do this if I've defined a 9 char ssn field? (and if so - how? substr?)
>
> tia - barb.

I would break the column into several separate columns and then create a view where I joined the separate columns into one big. The view would present both the separate values and the concatenated one. FWIW :-)

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.