ASP (VBScript) in Dreamweaver 8 1

[MichaelF81]

I am running .ASP connected to a SQL server 2000 back-end, and am trying to get this code to work. It is essentially a search page that pulls the entered text from the previous page. This query should take the text from the form, and find any record in any of those fields that is similar to the text entered. The "Like" command is not working and I need it to be so that if I enter 2, it can pull 123, 312, 213 and so on.

Thanks in Advance.

SELECT manuID, Manufacturer, Address, City, State, zipcode, Country, Phone, Fax, mfrEMail, Website, DearlDistributor, CDAvailable, Discount, LibraryLocation, AccountNum, LocalRep, Contact, RepAddress, RepCity, RepState, RepZipCode, RepPhone, repFax, RepEMail, LastUpdate, currentPriceList, AdditionalPhone, repWebsite
FROM dbo.tblManufacturers
WHERE (Manufacturer similar 's')
ORDER BY Manufacturer

 

[MichaelF81]

and I am aware that similar is not real, i put it in as a reminder to what I need.

Thanks

 

[Cheech]

You just need to add wildcards

WHERE (Manufacturer LIKE '%s%')

[Peace][Pipe]

 

[MichaelF81]

Cheech,

You make me feel like a complete fool. I have done this so many times and I get stuck on the little things more often than not. Thank you so much for your assistance, I greatly appreciate it.

Enjoy your star,

Michael