RE: SQL Order by clause
ah. by a PARTICULAR letter. :) WHERE Left(fieldname, 1) = 'letterinquestion' 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: Monday, April 01, 2002 2:07 PM To: CF-Talk Subject: RE: SQL Order by clause 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(, 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 __ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Order by clause
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(, 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
RE: SQL Order by clause
ORDER BY Left(, 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