Parameter INSIDE LIKE

[dooh]

Hi,

How can i create and select command with a paremter inside a LIKE funtion?

ex:
select name from clients where name LIKE '%' + :name + '%'

Some idea?

[Alexey]

What's wrong with this way:

Code: Select all

select name from clients where name LIKE :name

?