DataView.RowFilter - Sql Functions

[ralphtrent]

Hello
I am using the RowFilter to filter rows based on a Machine name. The machine name may be in all UpperCase or lowercase on the database. In sql I would use the lower() function to avoid having to know the actual case. I need to use that methodology when I filter rows in a dataview using the rowfilter property. When I do that, I get an error saying :

The expression contains undefined function call lower().

But this function is legit in Sql Server 2000. Is there an ADO.Net friendly way of doing this?

Thanks.

 

[tperri]

post your code so we can see what you're doing. thanks!

 

[ralphtrent]

it looks like CASE is not an issue, either case is working for me, but that may be because the instance of SqlServer was not installed with Case Sensitivity selected.

Thanks

 

[ca8msm]

How are the machine names getting into the datatable (i.e. could you just load them in as lowercase in the first place)?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ralphtrent]

Not a bad Idea. thanks.