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