Exact Search

[WebSlave]

I am trying to do an exact search using ASP, Access & IIS. I would like to be
able to type in an exact number (ie #4014) and have it come back with that
exact number.

Any suggestions? When I do LIKE it comes back with all of the numbers.

[Paul Whitham TMM]

If you want an exact search then use and = in the test with no wild card
values.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"WebSlave" <webforumsuser@macromedia.com> wrote in message
news:d5ejn1$ere$1@forums.macromedia.com...

> I am trying to do an exact search using ASP, Access & IIS. I would like

to be

> able to type in an exact number (ie #4014) and have it come back with that
> exact number.
>
> Any suggestions? When I do LIKE it comes back with all of the numbers.
>