[RESOLVED] incorrect syntax near % sql parameter

[KGComputers]

Hi,

I have this sql statement which will be passed to sql server 2008. This works fine.

string query = "Select * from Patient where LastName like '" + family + "%'";

However, when i tried to use a parameterized query like this:

string query = "Select * from Patient where LastName like '" + "@family" + " %'";

it gives me an error.

I tried putting a blank space before the @ sign. but its not doing right.

Any ideas? Btw, @family is sqldbtype.varchar.

tnx