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





    Tuesday, October 12, 2010 1:04 PM


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


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