How should I avoid the number split into two? Since I am not much into sql server, can you please help me that? I am getting now as follows:
LeftSide -dbo.SplitIds( '27,30,35,43,68 ,144,145,146,15 0,151,154,155,1 58,159,160,161, 162,163,165,166 ,167,168,169,17 0,1
71,
Middle -,1302,1303,1304 ,1305,1306,1307 ,1308,1309,1310 ,1311,1313,1314 ,1315,1316,1317 ,1318,1319,1320 ,1321,

How to do with charindex function?
...

I have a variable called @Joins, datatype is nvarchar(Max). Issue is I have a long string as follows:
27,30,35,43,68, 144,145,146,150 ,151,154,155,15 8,159,160,161,1 62,163,165,166. .......it's around 50,000 numbers. These are all id's and I need to process something with this id's. I am getting this id's in a variable called @Joins. However, while printing this variable, the data (ids) are truncating and getting only very few even though the...