Home Forums SQL Server 7,2000 T-SQL Problem with the text data column, variable RE: Problem with the text data column, variable

  • The article is good.

    But it did not had the solution of my problem. I have to receive a text field in which you cannot add any extra ',' anywhere .

    I have asked the front end people to send the parameter to add a comma at the last.

    I have the problem that when it is run in text field after certain time or point it just take 2 values from the values and dispalys.

    , which is incorrect.

    eg.

    I have a values '121212,1213231,3123,23,4444,4444,4444,444,4444,444,'

    i want it to be displayed like

    121212

    1213231

    3123

    23

    4444

    4444

    4444

    444

    4444

    444

    but it displays

    121212

    1213231

    3123

    23

    4444

    44

    44

    44

    44

    44

    Now I am in jinx where is the problem in my code , where is it breaking?