>Jim,
>
>Ok, one more time. I think I understand what it's doing now. My QUOTE_NO is a character field so I don't need to TRANSFORM it. My Density and Thickness fields are numeric so I need to do them. I've entered the following command:
>
>index on padl(quote_no,20)+padl(transform(density),20)+padl(transform(thickness),20) tag cost
>
>and get an error "too few arguments".
>
>John
John,
In this case you don't need to PADL the quote_no. The PADL is to control the length of the result of the TRANSFORM so your index expression can be;
INDEX ON quote_no + PADL(TRANSFORM(density),20)+PADL(TRANSFORM(thickness),20) TAG Cost