Thanks Will this solution also work with cases where the species names is like
Geranium australe Var. maculatum Coprosma sp "T" there are other naming combinations in the world of botany as well Mike ---------------------------------------------------- NZERN National Office Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- replace(species," ","_","all") HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "NZERN National Office" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 8:28 PM Subject: Species names > In a table is stored species names > eg > Oleria furfuracea > Parsonsia capularis > > I want to be able to convert this to a string like > > Oleria_furfuracea > Parsonsia_capularis > > so that links can be made like > > http://www.members.bush.org.nz/plant/fact.cfm?species=Aristotelia_serrata > > How do I do this? > > > Thanks for any help > > Mike > ---------------------------------------------------- > NZERN National Office > Mail: PO Box 9000, Christchurch > (03) 338-5451 > E-mail: [EMAIL PROTECTED] > http://www.bush.org.nz > ---------------------------------------------------- > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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