this would not do it. wat i weant was ordering a column starting with, for example,letter E, instead of A.
-----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:26 AM To: CF-Talk Subject: RE: SQL Order by clause ORDER BY Left(<fieldname>, 1) christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Thanh Nguyen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 7:52 PM To: CF-Talk Subject: OT: SQL Order by clause Hi all, How do I do an order by clause start with an alphabet letter. ? Is that possible ? Thanks Thanh ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists