locked
Need Split String Query RRS feed

  • Question

  • Hello,

    I am Using Database have following Fields,

    --------------------------------------

    S.No.          Name.          Phone Number

    ----------------------------------------

    1.          Rack               0245282:025428

    2.         Jamu               125475:125425

    3.         kali                  125487:045821

     

    Here I am using in Two text box phone number's in One field using ':' seprator.....

    but i want display in Asp.Gridview.. like

    ---------------------------------------------------------

    S.no   Name           Phone 1              Phone 2

    ----------------------------------------------------

    So I want SQL query for how to get Split function for seprateded Data Field.....

    help me

     

    Regd

    Riyaz

     

    Tuesday, October 12, 2010 1:04 PM

Answers

  • This forum deals specifically with Project and Project Server development. Please try one of the SQL Server forums.

    --Jim


    Jim Corbin [MSFT]
    Tuesday, October 12, 2010 3:29 PM