>I am having a problem selecting data for a table. It takes too long.
>
>The table has about 60,000 records in it. Is there a way to speed up the SQL Select statement without using SQL server?
>
>This is the syntax...
>
>SELECT * FROM &_table WHERE ALLT(LCTRANSNUM) == ALLT(MATRELEASE) AND LCCURRUSER == ALLT(NAME) ;
>INTO CURSOR DATASET
>
>
>Adam


Adam,

Supposing you have an index on MATRELEASE and NAME

try

LCTRANSNUM = padr(LCTRANSNUM, tothefieldlength)
LCTRANSNUM = padr(LCCURRUSER, tothefieldlength )

SELECT * ;
    FROM &_table ;
    INTO CURSOR DATASET ;
    WHERE ( MATRELEASE == LCTRANSNUM ) ;
     AND  ( NAME == LCCURRUSER )