>>Thank
>>
>>
>>I try with a UDF function but Error
>>
>>
>> PRIVATE ab
>> Ab = CREATEOBJECT("cruflaaa.CRUFLaaa")
>>WAIT WINDOW Ab.cAlltrimAmline( " testg ") Good result
>>
>>
>> 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 Ab.cAlltrimAmline( HDBK ) LIKE '<<Vp_in>>'
>> ENDTEXT
>>
>>
>>But here function Ab.cAlltrimAmline NOT defined !
>
>Why do you need to use UDF at all? If you want to get rid of spaces, use
>
> 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 RTRIM(LTRIM( HDBK )) LIKE '<<Vp_in>>'
> ENDTEXT
>
>Also, are you sure that it's valid to use STR function with dates?
or
> 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
Gregory