LIKE operator question

  • Thread starter Thread starter PJ6
  • Start date Start date
P

PJ6

LIKE is a noise word so I'm having trouble finding/googling information on
it.

The help in VS.NET was less than useful explaining this little quirk...

? "test.test.test" like "*.*"
True
? "test.test.test" like "*.*.*"
False

Is this expected behavior?

Paul
 
PJ6 said:
The help in VS.NET was less than useful explaining this little quirk...

? "test.test.test" like "*.*"
True
? "test.test.test" like "*.*.*"
False

Is this expected behavior?

There have been bugs with 'Like' pattern matchin in VB 7.*, for example
<URL:http://lab.msdn.microsoft.com/produ...edbackid=b8606152-01a5-4ef7-aefc-aa07b2d5c11f>.
Which version of VB.NET are you using? '"test.test.test" Like "*[.]*[.]*"
works fine in VB.NET 7.1, so I think the behavior for "*.*.*" is a bug.
 
PJ6 said:
LIKE is a noise word so I'm having trouble finding/googling information on
it.

The help in VS.NET was less than useful explaining this little quirk...

? "test.test.test" like "*.*"
True
? "test.test.test" like "*.*.*"
False

Is this expected behavior?

Try

? "test.test.test" like "*\.*\.*"
 
Addendum:

It's definitely a bug in VB 7.* that has fortunately been fixed in VB 2005!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top