Anyone notice that you can't use UPPER in the ORDER BY clause of a QofQ ?? Say for example: ORDER BY UPPER(accountName) Otherwise if you have mixed case it won't order properly...either that or I'm on crack. Any ideas?
<html><table border="1" width="" height=""><td width="" height=""><b><font face="Times New Roman" color="red" size="1"><span lang="FR-CA" style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: red; mso-bidi-font-size: 10.0pt; mso-ansi-language: FR-CA">AVIS IMPORTANT</span></font></b><font color="red" size="1"><span lang="FR-CA" style="FONT-SIZE: 8pt; COLOR: red; mso-bidi-font-size: 10.0pt; mso-ansi-language: FR-CA">:</span></font> <font color="black" size="1"><span lang="FR-CA" style="FONT-SIZE: 8pt; COLOR: black; mso-bidi-font-size: 10.0pt; mso-ansi-language: FR-CA">Les informations contenues dans le pr�sent document et ses pi�ces jointes sont strictement confidentielles et r�serv�es � l'usage de la (des) personne(s) � qui il est adress�. Si vous n'�tes pas le destinataire, soyez avis� que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohib�e. Si vous avez re�u ce document par erreur, veuillez s'il vous pla�t communiquer imm�diatement avec l'exp�diteur et d�truire ce document sans en faire de copie sous quelque forme.</span></font> <p style="text-align: justify; padding: 1"><b><font face="Times New Roman" color="red" size="1"><span style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: red; mso-bidi-font-size: 10.0pt">WARNING</span></font></b><font color="red" size="1"><span style="FONT-SIZE: 8pt; COLOR: red; mso-bidi-font-size: 10.0pt">:</span></font> <font color="black" size="1"><span style="FONT-SIZE: 8pt; COLOR: black; mso-bidi-font-size: 10.0pt">The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind.</span></font> </td></table></html> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
