Board index » VBA

All times are UTC



 Using FIND method to get Exact match 
Author Message
Bill
#1 / 2
 Using FIND method to get Exact match

I am trying to use the Find method to retreive all items in a folder
that have a specific subject (see below).

mymessages.Find("[Subject] = 'USA'")

My problem is that the Find method finds all items where the subject is
LIKE 'USA' rather than all items where the subject is EQUAL to 'USA'.

For example, it returns both these subjects.

Re: USA
USA

What is the best way to Find only the items that are exactly equal to
'USA'?



Tue, 23 Jul 2002 03:00:00 GMT  
Richard Wakema
#2 / 2
 Using FIND method to get Exact match
You will need to evaluate the subject field for each item Found.  I've had
the same dilemma.


Quote:
> I am trying to use the Find method to retreive all items in a folder
> that have a specific subject (see below).

> mymessages.Find("[Subject] = 'USA'")

> My problem is that the Find method finds all items where the subject is
> LIKE 'USA' rather than all items where the subject is EQUAL to 'USA'.

> For example, it returns both these subjects.

> Re: USA
> USA

> What is the best way to Find only the items that are exactly equal to
> 'USA'?



Wed, 24 Jul 2002 03:00:00 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. using Find Method for Exact match

2. Seek Nearest Match if exact match not found ?

3. Seek Nearest Match if exact match not found ?

4. Has the find method a partial match operator?

5. non-exact matches

6. exact matches in an array

7. Exact match in array?

8. Partial Matches using Restrict or Find

9. getting the exact time in VB 3.0

10. getting exact time in vb3.0

11. Finding exact directory

12. Finding the exact screen position of a UserControl?

  

 
Powered by phpBB® Forum Software