Mark Fitzgerald-331224 (3/12/2012)

---

I think that you may be looking to include the % as a search term as in the demo below. If this is the case use the...

ColdCoffee (3/12/2012)

---

Bro, when u see a empty string in the Frist Name text box (or wherever the value for @FirstName comes from) , handle it. Tell the user that it...

seth delconte (3/12/2012)

---

marly (3/12/2012)

---

I changed it to

SELECT * from dbo.mytable WHERE FirstName LIKE ‘%’ + REPLACE(@FirstName , ‘%’,’’) + ‘%’ but it still seems to put down the whole database...

I changed it to

SELECT * from dbo.mytable WHERE FirstName LIKE ‘%’ + REPLACE(@FirstName , ‘%’,’’) + ‘%’ but it still seems to put down the whole database if I do...