SQL
--
Questions
--
Followers
Top Experts
Extract a number for a string field in ms access query
Hello,
I need assistance in write a query to extract the number from a string field (See example below). The field will always have just one number in it and no decimal point. However, the number itself can be of any length. In the example below to number to extract will be: 214295600
# //STATION AGENCY="TEST " NUMBER="0214295600 " TIME_ZONE="EST" DST_FLAG=Y
Thank you.
I need assistance in write a query to extract the number from a string field (See example below). The field will always have just one number in it and no decimal point. However, the number itself can be of any length. In the example below to number to extract will be: 214295600
# //STATION AGENCY="TEST " NUMBER="0214295600 " TIME_ZONE="EST" DST_FLAG=Y
Thank you.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thank you all both solutions seems to accomplish the same thing although I have implemented harfang solution for its simplicity.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
SQL
--
Questions
--
Followers
Top Experts
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.