WHERE HDBK LIKE ?vp_in

give no cursor

AND i try without parameter and i have no records. ???

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 'F1        F4          FC'
      ENDTEXT

give no record ?

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

>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