User c29d691f4a

03-11-2010 15:36:26


  I would like to search for the percentage sign, %, in a text field.  Is there an escape character I can use to disable the symbol's wildcard properties?



Instant JChem Version: 5.3.4 (build: 100615)
JChem Version:
JChem Table Version: 5030300
Marvin Version:
5.3.4 (build date: 2010-06-15)
Java: 1.6.0_18; Java
HotSpot(TM) Client VM 16.0-b13
System: Windows XP version 5.1
running on x86; Cp1252; en_US (instantjchem)
NetBeans build:

ChemAxon fa971619eb

03-11-2010 16:19:16

It seems that this is not possible at present.

SQL does provide such a mechanism by specifying an escape character using a syntax like this:

SELECT name FROM emp WHERE id LIKE '%/_%' ESCAPE '/';

But IJC does not provide a way to specify the escape character.

Hoewever if you are uisng a MySQL database it seems that you are lucky as the backslash character is provided as the default escape character, so to find a value like 37% in a text field you can enter the term like this:


But if you are using a Derby local database or an Oracle database then you are out of luck.