>>>

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