Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > SqlDataSource FilterExpression doesn't support LIKE + 'String__' pattern

Reply
Thread Tools

SqlDataSource FilterExpression doesn't support LIKE + 'String__' pattern

 
 
wubin_98@yahoo.com
Guest
Posts: n/a
 
      04-07-2006
When I set a SqlDataSource1.FilterExpression value to " Partnumber LIKE
'87-2055-___'" , SqlDataSource return empty. But I can get correct
result in SQL query by including above expression.

I also found that FilterExpression only support % (Any string of zero
or more characters) in the end of string. For example, "Partnumber LIKE
'87-2055-%' (OK). But "Partnumber LIKE '87-20%-012'" (Error).

Could anyone give an explanation?

Thanks,

BWU

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
GridView - Changing FilterExpression of SQLDataSource and Paging Henry Habermacher [MVP Access] ASP .Net 2 07-31-2007 04:05 AM
sqldatasource filterexpression - Cannot find column jobs ASP .Net 1 01-29-2007 04:29 AM
sqldatasource filterexpression and paging lewis ASP .Net 0 01-10-2007 04:52 PM
sqldatasource filterexpression and paging lewis ASP .Net 0 01-09-2007 09:42 PM
Programmatically set FilterExpression and FilterParameters of SqlDataSource fuchs.markus@gmail.com ASP .Net 1 08-25-2005 02:24 PM



Advertisments