I should add that I am use a LIKE query, if that wasn't already implied.
Thanks

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Nathan Jobe
Sent: Monday, June 20, 2005 3:20 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support]

How do you add a literal % sign to your SQL queries and not have it take as
a wildcard ?

My users want to be able to search for 1% without coming with all things
that contain or end in 1

Thanks,
Nathan Jobe




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links