You want mid(). I think its mid(string, start, number of characters) So something like myString = mid(myString, 4, 4);
SHould be close, don't have the studio help files handy. Tim ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 8:35 PM Subject: String help > Hello, > > 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? > > Thanks > > D > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
