Parameter INSIDE LIKE

Parameter INSIDE LIKE

Postby dooh » Mon 29 Jan 2007 17:45

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?
dooh
 
Posts: 30
Joined: Sun 14 Jan 2007 21:11

Postby Alexey » Tue 30 Jan 2007 11:20

What's wrong with this way:
Code: Select all
select name from clients where name LIKE :name
?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL