Use subString
SELECT substring(lastName,1,1) FROM yourTable There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Diana Nichols" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 12:35 PM Subject: How to find first letter of last name... > I know there must be a simple way to do this....I have a field (playername) > which contains "firstname middlename lastname". I want to select by the > first letter of the lastname. I can do it with CF, or even JS, but can't > figure out how to write the SQL.....ideas? > > TIA! > D > > ************************ > Diana Nichols > Webmistress > http://www.lavenderthreads.com > 770.434.7374 > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
