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