Help with search results in asp vbs

[Chris]

I have this query:

SELECT *
FROM dbo.subwatch
WHERE subname like 'varsubname%' AND vendornum like 'varvendornum%' AND city
like 'varcity%' AND State like 'varstate%' AND reasonadded like 'varreason%'
ORDER BY subname

the problem is I need the vendornum to be = and not like... so if I search
for vendor# 123 id does not return results on vendor# 1234 and so on... if I
use = instead of like it does not return results if left empty... What am I
missing?

[Julian Roberts]

Try

vendornum like 'varvendornum'

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Chris]

Thanks Julian...

I thought I had tried that already... but it worked like a charm...

Thanks again!

Chris

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:cv30r3$ag2$1@forums.macromedia.com...

> Try
>
> vendornum like 'varvendornum'
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>