Using Absolute Value in RowFilter

[Auguy]

I was trying to use the following code.

dtTable.DefaultView.RowFilter = "Math.Abs(Company) = 2"

It doesn't work and I got around it, but was wondering what would work?

Auguy
Northwest Ohio

 

[RiverGuy]

dtTable.DefaultView.RowFilter = "Company = 2 OR Company = -2"

Or, add another column to your select statement:

SELECT *, ABS(Company) AS CompanyABS FROM SomeTable

dtTable.DefaultView.RowFilter = "CompanyABS = 2"

 

[Auguy]

Thanks RiverGuy, I can do that. Just thought I was missing something obvious.

Auguy
Northwest Ohio

 

[RiverGuy]

You might also try:

dtTable.DefaultView.RowFilter = "Abs(Company) = 2"

I'm not sure if RowFilter uses ANSI-SQL type syntax. If it does, and if ABS is an ANSI-SQL function, then that just might work.