Datatable.Select method - Difference Between %AE% and *AE*

Datatable.Select method - Difference Between %AE% and AE

microsoft.public.dotnet.framework.adonet

31 Mar 2005 7:12 AM

Palani

Hi,
Keyvalue :AETHAE
Keyvalue : AETH
The problem is that I am using the Datatable .select method and
Filter expression is %AE%.This Pattern is searchs only mid string not
with starting point.

Output: AETHAE

IF i use the *AE* , then searches from the starting point

Output: AETHAE and AETH

Pls. clarify...

Thanks
Palani

3 Apr 2005 3:13 PM

Bonnie Berent [C# MVP]

I get the same results whether using % or * ... and it searchs the whole
string, not just the starting point, just as I thought it should. Are you
sure your data is as you think it is? what is your entire Select Filter
string?

~~Bonnie

Show quote

"Palani" wrote:

> Hi,
> Keyvalue :AETHAE
> Keyvalue : AETH
> The problem is that I am using the Datatable .select method and
> Filter expression is %AE%.This Pattern is searchs only mid string not
> with starting point.
>
> Output: AETHAE
>
> IF i use the *AE* , then searches from the starting point
>
> Output: AETHAE and AETH
>
> Pls. clarify...
>
> Thanks
> Palani
>