SQL 2000 like clause in ASP code 1

[sandl4597]

Trying to get syntax right with doing a like clause in ASP. I have the user input any amount of characters meaning they can either enter the first letter or the entire agency name that they wish to find. I need a query that takes what they enter and search the database for these characters. Please advise how I can do this within ASP to avoid errors. Thanks.

 

[AWithers]

need to build up the sql then execute it in asp code or create a stored procedure in sql server and execute that passing it the string of characters ntered by the usere.g.

CREATE procedure ET_SP_ClientList
@client varchar(50) ='%'--default value, returns all
as
select ClientName
from
clientdata
where ClientName like ''+@client+'%

HTH

Andy

 

[sandl4597]

Can I do this without a stored procedure?

 

[JamesLean]

Using a stored proc is usually beter for performance but if you don't want to then use:

Dim strSearch
Dim strSQL

strSearch = Request.Form("myinput")

strSQL = "SELECT * FROM mytable WHERE myfield LIKE '" & strSearch & "%'"

--James