Home Forums SQL Server 2008 T-SQL (SS2K8) I need to compare and split the string and then save it in the detail_tb but dont know how ? RE: I need to compare and split the string and then save it in the detail_tb but dont know how ?

  • Thanks alot for responding and I check its perfect but do i need to add 'XX' to my string as My string is a message from another table ?

    I will do somthing like this :

    Select msg+'XX' from messageIn_TB where ..........

    Is this a corrrect way to do that ? I asking coz all the splitting of string is done when a INSERT TRIGGER is fired on MessageIN_Tb and I didnt tried that right now .....

    My thread link:

    http://www.sqlservercentral.com/Forums/Topic1365750-392-1.aspx?Update=1