In case someone may need this in future.

I found a solution to my problem from this site https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/.

A great article in there and I created a package based on it...

Thank you.

I will go through the link that you provided.

Thanks Anthony, that works for me.

anthony.green (6/12/2012)

---

I dont think there is in SSRS, but you could change the data set to include the RANK or DENSERANK function depending what you...

Lynn Pettis (4/25/2012)

---

Not sure what this would do performance wise, but it works without affecting double spaces inside of a string.

DECLARE @Area VARCHAR(50);

DECLARE @A2 VARCHAR(50);

SET @Area = 'GAUTENG EAST 1...

Thanks,

So having a check for char(9), char(10) and char(13) should cover me for the spaces?

I have implemented the function on my full query and seems to be working fine...

Hi all,

I find a solution for my problem.

It seems that there was line feed {char(10)} and that was looking like a space.

So I used:

REPLACE(@OutputFieldRecord, char(10), '')and this solved the problem.

I...

Hi bitbucket,

My function is already trimming the field but for some reason the trim did not work.

This leads me to believe that it is not a space but a funny...

how would I cater for the tab or double space?