What about using trim() after right()? I'm not clear on what you want, the SG part or the number that's left?
Jeff -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 11:59 AM To: CF-Talk Subject: Braindead stripping question Must....get....more....coffee... I have a variable passed, ie SG101 or SG 1004 I have to strip the first two characters as those are always constant. So I can't use right() since the numerical portions after the reliable two characters may fluctuate in terms of number of characters...what is best function to accomplish? TIA. Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
