thanks all, case close

thanks
ming2

--- In IBObjects@yahoogroups.com, "ming2_id" <ming2_id@...> wrote:
>
> Dear all,
>
> i am using SQLWhereItems, when using
> starting with comparation operator,
>
> TIB_Query, like this:
> select * from distributor
> column order by d_name
>
> TIB_QueryPrepareSQL, like this
> SQLWhereItems.Add( 'D_NAME STARTING WITH :D_NAME' );
>
> tib_searchedit, blue scheme, and can input text, and i get the result like d_name begin with comparation operator
> until this everything ok,
>
> but i want to change comparation operator with LIKE 'xxxxxx%'
> because i want to search D_NAME with ending, not starting.
>
> when i change TIB_QueryPrepareSQL, like this
> SQLWhereItems.Add( 'D_NAME LIKE :D_NAME%' );
> the tib_searchedit, color scheme black, it's cannot input text or error
>
> it's cannot work,
>
> how to solve this one?
> please some hints.
>
> thanks.
>
> ming2
>