>>Hi gregory,
>>
>>I put a picture with attachment.
>>
>>(Private)
>>vp_in ='/F1/F4/'
>>
>>
>> TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
>> SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY,
>> STR(Createdon) AS 'createdon' , hremint FROM <<.TABLES>>
>> ENDTEXT
>>
>>
>>This command give 42000 RECORDS...
>>
>>
>> TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
>> SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY,
>> STR(Createdon) AS 'createdon' , hremint FROM <<.TABLES>>
>>WHERE HDBK LIKE '/F1/F4/FC/ '
>> ENDTEXT
>>
>>This command give NO record and in do'nt understand the reason...
>>
>>
>>
>Alternatively, try
>
>
> TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
> SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY,
> STR(Createdon) AS 'createdon' , hremint FROM <<.TABLES>>
>WHERE HDBK LIKE '[F][14C]'
> ENDTEXT
>
Assuming that this syntax is supported, you may still need the % %
Gregory