<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html lang="en">
<head>
<title>Help: Simple SQL Query</title>
<link rel="stylesheet" type="text/css" href="/css/help.css" />
</head>
<body>
<h1>Simple SQL Query</h1>
<p class="classname">
Allows simple boolean logic to be applied to a search parameter eg
<ul id="id">
<li>Comment contains lymphoma</li>
<li>First name matches john</li>
<li>Last name begins with jon<sup>$</sup></li>
</ul>
</p>
<p class="classname">
The simple sql function can be used alone, or in combination with the main
form search fields. Note that if used in combination with the main form,
no attempt is made to 'sanitise' the search, so for example it is possible
to construct a search such as NHS number = 1111111111 and NHS number begins
with 222. In this case, the conflicting situation is resolved by the main
form field taking precedence over the simple sql search field. Use of the
same search field in both main form and simple sql search sections is not
currently supported.</p>
<p class="classname">Due to the dynamics of sql table indexing, some search
parameters (eg 'contains') will incur a performance penalty.</p>
<hr />
<p style="font-style= italic">
$ - which would return the same results as entering the same term in the
Last Name field of the main search form, as 'name' searches here are
effectively constructed as 'begins with'.
</p>
<form method="post">
<p align="center">
<input type="button" value="Close Window" onclick="window.close()">
</p>
</form>
</body>
</html>