Filter Names With an Asterix

[Mike C]

I have an account list. There's an asterix in the account name if it has
closed. For example, Acm* Corp. I don't agree with this design but that's
what our company came up with. Anyway, I'm trying to filter out these closed
accounts from my datagrids. In Access, I used to write WHERE ACCDESC NOT
"*[*]*" and that would filter them out. Not so in vb.NET. Anyone know how to
accomplish this? Thanks!

[Joshua Flanagan]

What do you mean by "VB.NET"? You must be using a specific .NET
Framework class to hold your data, which you are trying to filter.

I'll assume you are using the RowFilter property on a DataView. If not,
this answer may not apply.

With a DataView named dv, this should work:

dv.RowFilter = "accdesc not like '%[*]%'";
Joshua Flanagan
http://flimflan.com/blog
Mike C wrote:

I have an account list. There's an asterix in the account name if it has
closed. For example, Acm* Corp. I don't agree with this design but that's
what our company came up with. Anyway, I'm trying to filter out these closed
accounts from my datagrids. In Access, I used to write WHERE ACCDESC NOT
"*[*]*" and that would filter them out. Not so in vb.NET. Anyone know how to
accomplish this? Thanks!

[Mike C]

That worked perfectly. THANKS!

"Joshua Flanagan" wrote:

What do you mean by "VB.NET"? You must be using a specific .NET
Framework class to hold your data, which you are trying to filter.

I'll assume you are using the RowFilter property on a DataView. If not,
this answer may not apply.

With a DataView named dv, this should work:

dv.RowFilter = "accdesc not like '%[*]%'";
Joshua Flanagan
http://flimflan.com/blog
Mike C wrote:

I have an account list. There's an asterix in the account name if it has
closed. For example, Acm* Corp. I don't agree with this design but that's
what our company came up with. Anyway, I'm trying to filter out these closed
accounts from my datagrids. In Access, I used to write WHERE ACCDESC NOT
"*[*]*" and that would filter them out. Not so in vb.NET. Anyone know how to
accomplish this? Thanks!