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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]