Re: VB.NET question

Hi Mark
That is great. Now do you have a neat way of getting around the issue in
UV, Cache, QM etc. I definitely want users to be able to find Smith or
SMITH or smith by typing sMiTh. I am looking at running through the
database changing cases but I found a couple more such as tk1 or TK1 which
gets even messier. Even then it is hard to get users to understand why
their queries work in Windows Explorer and not in UV type Pick.
Regards
Peter McMurray

"Mark Brown" <mbrown@xxxxxxxxxxxxx> wrote in message
news:46a774bf$0$4700$4c368faf@xxxxxxxxxxxxxxxxx
VB usues LIKE as a match command.

Any VB help will tell you the syntax and options. Be carefull with OPTION
COMPARE TEXT and OPTION COMPARE BINARY are very important if you want aAa
to
equal AaA.

Mark Brown


"sh" <shamada@xxxxxxxxxxx> wrote in message
news:gkIpi.10783$tj6.9664@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I've posted this question on the VB.NET site, but I haven't gotten any
good answers yet (only "write your own procedure"). I'm posting it here
because MV people will know what I'm looking for, and maybe some of the
.NET people here will have the solution.

I'm looking for the VB.NET equivalent of our beloved MATCH statement.
For
instance, IF X MATCH "4N" or IF X MATCH "3N1A2N" or IF X MATCH
"2N'-'2N",
or IF X MATCH "0A", etc.

I thought a regular expression (RegEx) might work, but I find its'
language so complex I can't even get started with it (I need an easy
step
by step tutorial, but haven't found one yet). And even then, I'm not
sure
it does what I want.

Anyone have any ideas? Thanks.

Sholom




.