GUIDO22
Registered User.
- Local time
- Today, 16:24
- Joined
- Nov 2, 2003
- Messages
- 515
I have a query that uses the following LIKE condition...
This returns all items where the OD(Outer diameter of components) broadly matches the search criteria.
However, my stock of components has sizes : 16mm and also 160mm...
If my query search string is '16'... currently, I also get matches on sizes that are 160mm .. I dont want this..
I need the search to be specific to the number of significant figures as specified.... so a search for '16' returns all diameters of 16, 16.40, 16.65 etc
Thanks in advance for any help..
Code:
Like [Search for OD?] & "*"
This returns all items where the OD(Outer diameter of components) broadly matches the search criteria.
However, my stock of components has sizes : 16mm and also 160mm...
If my query search string is '16'... currently, I also get matches on sizes that are 160mm .. I dont want this..
I need the search to be specific to the number of significant figures as specified.... so a search for '16' returns all diameters of 16, 16.40, 16.65 etc
Thanks in advance for any help..