Problems Filtering on a Char(10) Data Type

[John Thelen]

Hello,

I have a Microsoft SQL Server database table with a field defined as a Char(10).  When I define a filter to use this field, the filter doesn't seem to work.  I can filter on any of the nvarchar() type fields but just not this Char(10) field.

The value in the database table is IHOPC491.  When filtering on this field, I've attempted to use various operators including = and like -- but no joy.

I'm using the Telerik.Reporting.SqlDataSource data connector.

Any thoughts on what I might do to get around this problem?

Thanks!

[John Thelen]

Never Mind ... Resolved my own problem.

I had a "top 300" included in my SQL Query and it turns out the value of IHOPC491 didn't exist within the first 300 records.