Bernhart,

all what I can think of is

get table structure via

COPY STRUCTURE EXTENDED TO FileName

Field "Field_Name" contains all Fields

now something like (does not work)

select Source
COPY STRUCTURE EXTENDED TO tabStruct
sele 0
use tabStruct
lcHelp = ""
scan for Field_Name='D_'
lcHelp = lcHelp+','+alltrim(Field_Name)
endscan

lcSQL = "SELECT "+strtran(lcHelp,',','',1,1)+" FROM Source INTO CURSOR curXYZ NOFILTER"
&lcSQL

HTH

Lutz
>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