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