>>>index on dupkey+codex + Cast(2^31-1- Cast(strtran(COPYNO, chrtran(COPYNO, '0123456789', '')) AS I) AS M) DESCENDING TAG docky
>>
>>Thanks I will try it
>
>update
>
>
>index on dupkey+codex + Padr(Cast(2^31-1- Cast(strtran(COPYNO, chrtran(COPYNO, '0123456789', '')) AS I) AS M), 10) DESCENDING TAG docky
Thanks I will try it - but I have realised there is a solution which makes the complex indexing unnecessary - but will try it for future refeerence
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing