How to write a query to get the digit in "TextDigitText" 2

[kia70]

I have a column which contains "text digit text" as "AAA 222 BBB". The numbers of letters or digits can vary.

I need to SELECT the column which contains digits in a specific interval. For Example I have
"DFS 673 JKK"
"A 3454 LJLJ"
"SD 854 JKLJD"

I need to SELECT the column which contains 600 < Digit < 700 the result of the query in this case would be "DFS 673 JKK" because 673 is between 600 and 700.

Thanx for any clue or suggestion...

 

[lespaul]

I believe the VAL function does that, try:

SELECT * FROM TableName WHERE Val(FieldName) Between 600 and 700

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[PHV]

WHERE Val(Mid(yourField,1+InStr(yourField," "))) Between 600 And 700

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

drats, I was so close!

 

[kia70]

Thank you PHV. You open the door to a new world for me. The functions you wrote for me led med to new functions which I didn't know it excist at all.... And your solution was pefect.