<html><body>
<p><font size="2" face="sans-serif">In Advanced Search, allowed </font><font size="2" face="sans-serif">are % (matching exactly 1 character) or * (matching 0 or any number of characters). Wildcards are only trailing.</font><br>
<br>
<font size="2" face="sans-serif">So something like na* should match those words that start with Na.</font><br>
<br>
<font size="2" face="sans-serif">See also </font><a href="http://www.zora.uzh.ch/help/"><font size="2" face="sans-serif">http://www.zora.uzh.ch/help/</font></a><br>
<br>
<font size="2" face="sans-serif">What is not clear to me whether your chemical systems describe general compositions (Sodiumtoluenesulfonate with an arbitray amount of crystal water, e.g. CAS RN 1240939-71-2, Sodium(1+), aqua-, 4-methylbenzenesulfonate (1:1), C7 H7 O3 S . H2 O . Na, CAS RN </font><font size="2" face="sans-serif">28573-41-3, Benzenesulfonic acid, 4-methyl-, sodium salt, hydrate (2:2:1), C7 H8 O3 S . 1/2 H2 O . Na , and CAS RN 337511-98-5, C7 H8 O3 S . x H2 O . Na, Benzenesulfonic acid, 4-methyl-, sodium salt, hydrate (1:1:?)) or just the exact mono-hydrate system: CAS RN 1240939-71-2.</font><br>
<br>
<font size="2" face="sans-serif">If the latter, as a chemical information specialist, I strongly suggest to use either standardized English IUPAC names or CAS names for your chemical systems and in addition use either CAS Registry Numbers or InChI.</font><br>
<br>
<font size="2" face="sans-serif">Best regards,</font><br>
<br>
<font size="2" face="sans-serif">Martin</font><br>
<br>
<font size="2" face="sans-serif">--</font><br>
<font size="2" face="sans-serif">Dr. Martin Brändle</font><br>
<font size="2" face="sans-serif">Zentrale Informatik</font><br>
<font size="2" face="sans-serif">Universität Zürich</font><br>
<font size="2" face="sans-serif">Stampfenbachstr. 73</font><br>
<font size="2" face="sans-serif">CH-8006 Zürich</font><br>
<br>
<img width="16" height="16" src="cid:1__=4EBBF446DFB1A0C48f9e8a93df9@lotus.uzh.ch" border="0" alt="Inactive hide details for Thomas Lauke ---02/10/2015 18:20:10---> Could you give a little more context? we like to realize some"><font size="2" color="#424282" face="sans-serif">Thomas Lauke ---02/10/2015 18:20:10---> Could you give a little more context? we like to realize something similar to</font><br>
<br>
<font size="1" color="#5F5F5F" face="sans-serif">Von: </font><font size="1" face="sans-serif">Thomas Lauke <th.lauke@arcor.de></font><br>
<font size="1" color="#5F5F5F" face="sans-serif">An: </font><font size="1" face="sans-serif">eprints-tech@ecs.soton.ac.uk</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Datum: </font><font size="1" face="sans-serif">02/10/2015 18:20</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Betreff: </font><font size="1" face="sans-serif">[EP-tech] Re: search for 2-character-string</font><br>
<font size="1" color="#5F5F5F" face="sans-serif">Gesendet von: </font><font size="1" face="sans-serif">eprints-tech-bounces@ecs.soton.ac.uk</font><br>
<hr width="100%" size="2" align="left" noshade style="color:#8091A5; "><br>
<br>
<br>
<tt><font size="2">> Could you give a little more context?<br>
we like to realize something similar to<br>
<br>
mysql> select * from eprint_system where system like '%na%';<br>
+----------+-----+-------------------------+<br>
| eprintid | pos | system |<br>
+----------+-----+-------------------------+<br>
| 6550 | 0 | binary oceanic |<br>
| 8468 | 7 | Na-p-Toluensulfonat-H2O |<br>
| 8468 | 6 | Li-p-Toluensulfonat-H2O |<br>
:<br>
<br>
but want to search for 'na-%' likewise ...<br>
<br>
Currently just a search for the complete system string, like<br>
'Item Status matches any of "User Workarea", "Under Review", "Live Archive" AND System is "binary oceanic"',<br>
is successful ...<br>
<br>
Thanks in advance<br>
Thomas<br>
*** Options: </font></tt><tt><font size="2"><a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a></font></tt><tt><font size="2"><br>
*** Archive: </font></tt><tt><font size="2"><a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a></font></tt><tt><font size="2"><br>
*** EPrints community wiki: </font></tt><tt><font size="2"><a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></font></tt><tt><font size="2"><br>
*** EPrints developers Forum: </font></tt><tt><font size="2"><a href="http://forum.eprints.org/">http://forum.eprints.org/</a></font></tt><tt><font size="2"><br>
</font></tt><br>
</body></html>