Wildcards are not allowed in the middle of the String (Dataset Fil

[Anandan]

Hi,

This is regarding Dataset Filter:

WILDCARD CHARACTERS

Both the * and % can be used interchangeably for wildcards in a LIKE
comparison. If the string in a LIKE clause contains a * or %, those
characters should be escaped in brackets ([]). If a bracket is in the clause,
the bracket characters should be escaped in brackets (for example [[] or
[]]). A wildcard is allowed at the beginning and end of a pattern, or at the
end of a pattern, or at the beginning of a pattern. For example:

"ItemName LIKE '*product*'"

"ItemName LIKE '*product'"

"ItemName LIKE 'product*'"

Wildcards are not allowed in the middle of a string. For example, 'te*xt' is
not allowed.

The above given by MSDN notes,

I want to know any resolution on this ,

Wildcards are not allowed in the middle of the String (Dataset Filter) or
remain
same ??.

Thanks
Anandan k

[Ken Tucker [MVP]]

Hi,

This will not work.
ds.Tables("Products").DefaultView.RowFilter = "ProductName Like 'C%G'"

This will
ds.Tables("Products").DefaultView.RowFilter = "ProductName Like '%G' and
ProductName Like 'C%'"
Ken
-----------------------------
"Anandan" <An*****@discussions.microsoft.com> wrote in message
news:83**********************************@microsof t.com...
Hi,

This is regarding Dataset Filter:

WILDCARD CHARACTERS

Both the * and % can be used interchangeably for wildcards in a LIKE
comparison. If the string in a LIKE clause contains a * or %, those
characters should be escaped in brackets ([]). If a bracket is in the
clause,
the bracket characters should be escaped in brackets (for example [[] or
[]]). A wildcard is allowed at the beginning and end of a pattern, or at the
end of a pattern, or at the beginning of a pattern. For example:

"ItemName LIKE '*product*'"

"ItemName LIKE '*product'"

"ItemName LIKE 'product*'"

Wildcards are not allowed in the middle of a string. For example, 'te*xt' is
not allowed.

The above given by MSDN notes,

I want to know any resolution on this ,

Wildcards are not allowed in the middle of the String (Dataset Filter) or
remain
same ??.

Thanks
Anandan k