Using SELECT LIKE with ADO Parameter in ASP Page

[codeurai]

Is it possible and how do I do use a select like query with an ado
command's parameter object?

For Example:
Instead of this:
command.CommandText = "SELECT * FROM Table WHERE field LIKE
'%searchString%'

This:
command.CommandText = "SELECT * FROM Table WHERE field LIKE '%?%'
command.Parameters.Append(command.CreateParameter ....

Thanks

[Michael Teja via SQLMonster.com]

Sorry,
but can u give the complete answer.

Cause I don't understand about the append param can make change the sign '?
'.
Than

--
Message posted via http://www.sqlmonster.com

[codeurai]

Sure,
I use the ? to denote parameters, you can also use something like
@searchString with an "@" to denote parameters just like in a sproc, so
the full example would be:

searchValue = "Joe"
command.CommandText = "SELECT * FROM Table WHERE field LIKE
'%@searchString%';
command.Pararameters.Append(command.CreateParamete r("@searchString",
adVarChar, adParamInput, 2000, searchValue))

[Erland Sommarskog]

codeurai (co******@yahoo.com) writes:

Is it possible and how do I do use a select like query with an ado
command's parameter object?
For Example:
Instead of this:
command.CommandText = "SELECT * FROM Table WHERE field LIKE
'%searchString%'

This:
command.CommandText = "SELECT * FROM Table WHERE field LIKE '%?%'
command.Parameters.Append(command.CreateParameter ....

command.CommandText = "SELECT * FROM Table WHERE field LIKE '%' + ? '%'

should cut it.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp