At 00:35 10/07/2003 +0000, you wrote: >I'm outputing a query and have a part number value. The part number >value is syntacically the same, (SSS444BBB) The first part of the part >number is three letters, then three numbers. I want to extract the >three numbers from this part number. Any suggestions?
If it's always always going to be in that position, this should work: <cfset number = Mid(partNumber, 4, 3)> Gyrus [EMAIL PROTECTED] play: http://norlonto.net/ work: http://tengai.co.uk/ PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
