In one word no.
When you create an index you create it based on whole columns not
partial columns.
You could break up the ssn into seperate columns if this is really
needed.
On Tue, 28 Jan 1997 14:06:20, BEH_at_csd.uwm.edu (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.
Received on Wed Jan 29 1997 - 00:00:00 CST
