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

Discussion in 'ASP .Net' started by wubin_98@yahoo.com, Apr 7, 2006.

  1. Guest

    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
     
    , Apr 7, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    1
    Views:
    7,580
    Markus
    Aug 25, 2005
  2. Henry Habermacher [MVP Access]

    GridView - Changing FilterExpression of SQLDataSource and Paging

    Henry Habermacher [MVP Access], Jan 20, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    11,249
    kmarchiony
    Jul 31, 2007
  3. lewis
    Replies:
    0
    Views:
    484
    lewis
    Jan 9, 2007
  4. lewis
    Replies:
    0
    Views:
    527
    lewis
    Jan 10, 2007
  5. jobs
    Replies:
    1
    Views:
    1,277
    =?Utf-8?B?SmFzb24gVmVybWlsbGlvbg==?=
    Jan 29, 2007
Loading...

Share This Page