Thank you very much...
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> ha scritto nel messaggio
news:cdj8bu$fsd$1_at_titan.btinternet.com...
>
> It is not possible to do what you want, and
> the approach of concatenating bits of string
> into a single field is not a good idea.
>
> However, you can get quite close to your requirement
> by adding an extra column to your table, and populating
> it with a before insert/update row trigger that extracts
> the character from the longer string.
>
> You can then partition on the single character column.
>
Received on Tue Jul 20 2004 - 09:58:50 CDT
