<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri" size="2"><span style="font-size:11pt;">
<div>Hello,</div>
<div> </div>
<div>Environment:</div>
<div>AIMS 2012, IIS7, Windows 2008 server (64)</div>
<div>Parcels layer in MS SQL Server 2008 R2 (spatial)</div>
<div> </div>
<div>In working with the search command in the basic web layout and query in the fusion I keep hitting the same question. Is there a method to sort the results?</div>
<div> </div>
<div>To accomplish a parcel number areas search my search term in the basic layout is LAPN LIKE ‘$USER_VARIABLE%’ . The trailing % allowing for partial apn. Having an ORDER BY LAPN would help things. Ditto for the query in the fusion layout.</div>
<div> </div>
<div>Thanks for any insight that might be available.</div>
<div> </div>
<div>tom</div>
<div> </div>
<div> </div>
</span></font>
</body>
</html>