Received: from asplists.lyris.net (asplists.lyris.net [216.91.56.101])

From: "Ryan Trudelle-Schwarz"
To: "aspdatabases"
Subject: [aspdatabases] RE: SQL Query with percentage sign???
Date: Fri, 27 Oct 2000 19:58:06 -0400
Reply-To: "aspdatabases"

Putting it in square brackets should work:

LIKE '20[%]'

hth, Ryan

--*--*--*--*--*--*--*--*--*--*--*--*--
www.Mamanze.com
ASP Code Samples
--*--*--*--*--*--*--*--*--*--*--*--*--

--> -----Original Message-----
--> From: Jason Rosenberg [mailto:jason.rosenberg@priorityhealthcare.com]
--> Sent: Friday, October 27, 2000 6:16 PM
--> To: aspdatabases
--> Subject: [aspdatabases] SQL Query with percentage sign???
-->
-->
--> List,
-->
--> Could someone clear my head of the cobwebs and refresh my
--> memory on how to
--> do a 'LIKE' SQL Query that would contain a percentage sign as
--> part of the
--> search string. I want the percentage sign in the search string to be
--> counted as part of the string. We will have some people searching for
--> '20%'.
-->
--> Thanks.
-->
--> -Jason