How about something like

SELECT mutable
nFields = AFIELDS(aFlds)
lcFields = ""
FOR iField = 1 TO nFields
     IF aFlds[iField,1] = "D_"
        lcFields = lcFields+","+aFlds[iField,1]
    ENDIF
ENDFOR

IF EMPTY(lcFields)
    MESSAGEBOX("No Fields Found")
ELSE
    lcSql = "SELECT " + SUBSTR(lcFields,2) + " FROM mutable INTO CURSOR myCursor READWRITE
    &lcSql
ENDIF

>Hi all,
>
>i want use a sql command.
>I want only filter the fields of my table beginning by D_ ( ex d_date … d_ stop )
>
>select *.d from mutable is bad…
>
>which command can i use ?
>
>Thank in advance
>
>
>bernhart