Re: How do you get middle 4 numbers out of agent code number

2002-02-13 Thread one
This code below works great, but how bout if you wanted the second set of 4 numbers from the left. i.e. Lets say someone provides an agent number of ' 123456789123' and it needs to be split into 3 parts with 4 charcters each: Master=1234 Region=5678 Agent=9123 Because there is a signup

Re: How do you get middle 4 numbers out of agent code number

2002-02-13 Thread Bryan Stevenson
- Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 3:17 PM Subject: Re: How do you get middle 4 numbers out of agent code number This code

RE: How do you get middle 4 numbers out of agent code number

2002-02-13 Thread Steve Oliver
:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 6:17 PM To: CF-Talk Subject: Re: How do you get middle 4 numbers out of agent code number This code below works great, but how bout if you wanted the second set of 4 numbers from the left. i.e. Lets say someone provides an agent number

Re: How do you get middle 4 numbers out of agent code number

2002-02-13 Thread Jon Hall
PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 6:17 PM Subject: Re: How do you get middle 4 numbers out of agent code number This code below works great, but how bout if you wanted the second set of 4 numbers from the left. i.e. Lets say someone provides an agent

Re: How do you get middle 4 numbers out of agent code number

2002-02-13 Thread one
Thankyou very much, that worked like a charm. - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 3:22 PM Subject: RE: How do you get middle 4 numbers out of agent code number Then you would use Mid() Mid(string