Can we write custom function to filter rows from DataTable

Discussion in 'ASP .Net' started by ArunDhaJ, Jul 4, 2008.

  1. ArunDhaJ

    ArunDhaJ Guest

    Hi,
    Can we write custom function to filter rows from DataTable Select
    method?

    Actually my need is to format the row value
    from
    (901) 789 1234<BR>(901) 789 1235<BR>(901) 789 1221
    to
    9017891234<BR>9017891235<BR>9017891221
    (removing all formatting strings)

    I've tried in SQL with Replace function. But giving Unknown Function
    REPLACE() error in trying to run in DataTable Select method.

    How can we write a custom function to format the string if any
    possible....

    Thanks in Advance
    - ArunDhaJ
     
    ArunDhaJ, Jul 4, 2008
    #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. J. Babe
    Replies:
    1
    Views:
    8,401
    Kevin Spencer
    Aug 15, 2003
  2. Fredrik Rodin

    Sort a datatable and create a new datatable

    Fredrik Rodin, Feb 16, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    9,100
    paul.mariotti
    Sep 28, 2007
  3. =?Utf-8?B?Qmx1ZWZsb3dlcg==?=

    Casting DataTable to class inherit from DataTable

    =?Utf-8?B?Qmx1ZWZsb3dlcg==?=, Apr 2, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    1,021
    =?Utf-8?B?Qmx1ZWZsb3dlcg==?=
    Apr 2, 2004
  4. jg
    Replies:
    1
    Views:
    751
    =?Utf-8?B?U2hhaWxlc2ggSmFubnU=?=
    Aug 17, 2004
  5. Ersin Gençtürk
    Replies:
    1
    Views:
    3,541
    Ersin Gençtürk
    Oct 6, 2004
Loading...

Share This Page