Received: from asplists.lyris.net (asplists.lyris.net [216.91.56.101])
From: "Ryan Trudelle-Schwarz" <ryan@mamanze.com>
To: "aspdatabases" <aspdatabases@ls.asplists.com>
Subject: [aspdatabases] RE: SQL Query with percentage sign???
Date: Fri, 27 Oct 2000 19:58:06 -0400
Reply-To: "aspdatabases" <aspdatabases@ls.asplists.com>

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