FilterExpression LIKE wildcard doesn’t work?
Is it just me, or does the wildcard ‘%’ NOT work when setting the FilterExpression on an ObjectDataSource in .NET 2.0? Instead of the usual ‘%’ character, I have found that the asterisk ‘*’ is much more reliable. For example, the following statement returned no rows:
dsDocuments.FilterExpression = 'title LIKE '%Engineering%'
but this DID work:
dsDocuments.FilterExpression = 'title LIKE '*Engineering*'
MSDN documentation says that both forms are equivalent, but apparently not, at least in my experience.
