Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parse - specific number combination
Thanks! I have it working as: ----------- If TARGET Like "10#####" Or TARGET Like "20#####" Or TARGET Like "80#####" Then ----------- The one thing I forgot to mention is to look for delimiters at the end of the combination. These numbers are usually separated by one of many delimiters (/...- MRKCK
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Parse - specific number combination
I need a function that will test if a text field (of any length) has a 7 digit number combination that begins only with a "10", "20", or "80" and if so, return the 7 digit combination. Something like the the function provided to Dave177 by willybgw (amazing work!) would be perfect if it can be...- MRKCK
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
