<CFIF LEFT(LASTNAME,1) IS "A">#LASTNAME#</CFIF> HTH, Jim Vosika http://www.softwaresupermall.com
-----Original Message----- From: Kent A. Orso [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:11 AM To: CF-Talk Subject: CFIF Statement Trying to do a CFOUTPUT Statement that returns all of the lastname records that begin with the letter "A", and order by lastnames, but the following is not working, any ideas? <cfif LASTNAME IS "A">#LASTNAME#</cfif> Thanks in advance, Kent ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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

