try




>

>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>>
>WHERE HDBK LIKE  ?vp_in
>		      ENDTEXT
>

>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...
>
>
>
>
>
>
>
>
>
>>>>>I'm assuming that '%' is included into Vp_in already, because otherwise I don't see a reason for using LIKE and not = at all.
>>>>
>>>>In that case, there's no need to trim, is there ?
>>>
>>>No need to trim, you're right. I'm wondering why Bernhart insists on trimming.
>>
>>
>>Maybe the %'s aren't in after all