>>>>
>>>> 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 % %
>>
>>Why? I want the first character to be F and the next to be 1,4 or C.
>
>
>I understand - but since we don't know what that field may contain, the % may be necessary
>
>It may contain something like
>
>C1/F4/P7
>
>
>
>In any case - there's not enough information to judge
Right - I assumed that we wanted to extract records with F1 or F4 or FC for the HdBk by looking at the results provided in the screenshot.
If it's not broken, fix it until it is.
My Blog