Search and display records. 2

[alan28]

I want to have a search and display records page on my site. I need to search for names and return their records. Say I search for john smith I want this record to be displayed if someone types "john" or "smith". What is the SQL for that?

 

[lesleint]

SELECT * FROM dbo.YourDB WHERE field LIKE '%Parameter%'

 

[Cheech]

or

SELECT * FROM tblYourTable WHERE firstName LIKE 'Parameter%' OR lastName LIKE 'parameter2%'

[Peace][Pipe]
The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[alan28]

Thank you both.

 

[Cheech]

Your welcome.

[Peace][Pipe]
The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[alan28]

I still can not get it to work. This is want I am inputing.

SELECT *
FROM speed
WHERE FNname LIKE %FNname%

FNname % Request.QueryString("FNname&quot

I am getting a snytax error in query expression '% LIKE %%%'

Where I am going wrong?

 

[Cheech]

do a response.write of your sql statement before it executes to see exaclty what is happening, I think you need to put single ' quotes around the variable

Cheech

[Peace][Pipe]
The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)