>>>>>

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


Oh, I didn't see the screenshot. In that case an IN clause may be best like you have suggested