<div class="Section1"><p class="MsoNormal">Say I have the following SQL statement:<p class="MsoNormal"> <p
class="MsoNormal">SELECTa, b, c FROM t1 ORDER BY a;<p class="MsoNormal"> <p class="MsoNormal">Is there a function or
specialsystem label I can use that would generate a sequence number in the returning result set?<p
class="MsoNormal"> <pclass="MsoNormal">Example:<p class="MsoNormal">SELECT a, b, c, SOMELABEL as order FROM t1 ORDER BY
a;<pclass="MsoNormal"> <p class="MsoNormal">Result:<p class="MsoNormal">a b c order<p
class="MsoNormal">---------------------<pclass="MsoNormal">Aa bb cc 1<p class="MsoNormal">A1 bb cc 2<p
class="MsoNormal">A2 bb cc 3<p class="MsoNormal"> <p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">Thanks,</span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif""> </span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">LanceCampbell</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""></span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">ProjectManager/Software Architect</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif"">Web Services at Public
Affairs</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">University of
Illinois</span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">217.333.0382</span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif""><ahref="http://webservices.uiuc.edu/"><span
style="color:blue">http://webservices.uiuc.edu</span></a></span><pclass="MsoNormal"> </div>