Page 1 of 1

Parameter INSIDE LIKE

Posted: Mon 29 Jan 2007 17:45
by 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?

Posted: Tue 30 Jan 2007 11:20
by Alexey
What's wrong with this way:

Code: Select all

select name from clients where name LIKE :name
?