trying to query exchange server with WQL and like/wildcard

[bslintx]

ok, i'm at wits end here

i am trying to query exchange server using like, however i receive "Could not complete operation due to error 80041024"

this is the code that has the error:

 Set SWbemLocator = CreateObject("WbemScripting.SWBemlocator")
     Set objWMIService = SWBemlocator.ConnectServer _
         ("excchangeserver123", "root\MicrosoftExchangeV2","Domain\admin","123456789")


     Set colItems = objWMIService.ExecQuery("SELECT * FROM Exchange_Mailbox WHERE MailBoxDisplayName LIKE 'joe*'")


    for each objItem in colItems

      
         sResults = sResults & objItem.MailboxDisplayName & " " &  objItem.StoreName & "<br>"
        
        
       
   next

 results.innerhtml = sResults

every google query i came upon when using the like statement and WQL(sql subset) needs to be xp...i have xp pro and server is 2003....i am totally lost as this code is presented everywhere but i am having problems tracking down the mistake...please advise...i'm going nuts

code that does work with where statement but w/o like

 Set SWbemLocator = CreateObject("WbemScripting.SWBemlocator")
     Set objWMIService = SWBemlocator.ConnectServer _
         ("excchangeserver123", "root\MicrosoftExchangeV2","Domain\admin","123456789")


     Set colItems = objWMIService.ExecQuery("SELECT * FROM Exchange_Mailbox WHERE ServerName = 'joe'")


    for each objItem in colItems

      
         sResults = sResults & objItem.MailboxDisplayName & " " &  objItem.StoreName & "<br>"
        
        
       
   next

 results.innerhtml = sResults

 

[bslintx]

forgot to mention...it's a .hta....i'm sure that was inplied w/ the innerhtml but just in case...thanks

 

[dm4ever]

Did you try using % instead of * ?

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[bslintx]

unfortunately yes...i can't for the life of me understand why it doesn't work....if someone has successfully ran the like in this situation...please let me know....it would be appreciated....

btw....i can obviously grab all mailboxes (2000+) in this case and loop with an instr but i'd rather return only the records i need and loop 14 vs 2000+

 

[bslintx]

also...the * was the wrong one posted ...all demos used %...it just happened to be the last one i was experimenting with on a copy/paste/post...good eye dm4ever