No worries ;-) -----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 01 February 2002 16:30 To: CF-Talk Subject: Re: Substring function in query
Never mind my last comment. See what happens when you have not finished your coffee and do not read an entire post. Sorry Craig!!! 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: "Mark Leder" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 8:07 AM Subject: RE: Substring function in query > The LEFT function does work, thanks. > > Mark > > -----Original Message----- > From: Craig Dudley [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 01, 2002 10:41 AM > To: CF-Talk > Subject: RE: Substring function in query > > > Try > > SELECT f_ID, Common_Name, Botanical_Name, LEFT(Botanical_Name,1) AS > Alpha1 > FROM p_FloralContent > ORDER BY Botanical_Name ASC > > hth, > Craig > > -----Original Message----- > From: Mark Leder [mailto:[EMAIL PROTECTED]] > Sent: 01 February 2002 15:38 > To: CF-Talk > Subject: Substring function in query > > > When I construct the following SQL statment, I get an undefined > function > error. I'm trying to extract the first letter of the Botanical_Name > column > (full text string) and create an alias column (of A, B, C, D, etc). > What am > I doing wrong? > > SELECT f_ID, Common_Name, Botanical_Name, SUBSTRING(Botanical_Name,1,1) > AS > Alpha1 > FROM p_FloralContent > ORDER BY Botanical_Name ASC > > Thanks, > Mark > > > ______________________________________________________________________ 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
