467,169 Members | 974 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

Extract part of record using SQL

I have a record with, for instance 000-11-222-33 as text.
Is there a way to extract just the 222 part? With the sidenote that the 222
part kan have 3 or 4 characters.
The 000 and 11 part are always 3 and 2 characters each.

Thanks!

Mar 23 '06 #1
  • viewed: 1418
Share:
2 Replies
On Thu, 23 Mar 2006 20:49:17 +0100, Eagle wrote:
I have a record with, for instance 000-11-222-33 as text.
Is there a way to extract just the 222 part? With the sidenote that the 222
part kan have 3 or 4 characters.
The 000 and 11 part are always 3 and 2 characters each.

Thanks!


Val(Mid([FieldName],8))
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Mar 23 '06 #2

"fredg" <fg******@example.invalid> schreef in bericht
news:1o******************************@40tude.net.. .
On Thu, 23 Mar 2006 20:49:17 +0100, Eagle wrote:
I have a record with, for instance 000-11-222-33 as text.
Is there a way to extract just the 222 part? With the sidenote that the
222
part kan have 3 or 4 characters.
The 000 and 11 part are always 3 and 2 characters each.

Thanks!


Val(Mid([FieldName],8))
--
Fred


Thanks for the quick response Fred.
Will this give the value from position 8 and up (222-33) or just 222?
I'll give it a go anyway ;-)
Mar 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Alvin Sebastian | last post: by
1 post views Thread by vjp2.at@at.BioStrategist.dot.dot.com | last post: by
8 posts views Thread by Fabian Braennstroem | last post: by
9 posts views Thread by flit | last post: by
7 posts views Thread by erikcw | last post: by
18 posts views Thread by Ecka | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.