Hi,

I have a slightly similar problem

I hav a nvarchar field with no particular format of where spaces are

I want to split the string as below

<all chars-3> space <last 3 chars>

Eg: "ABCDEFG" should appear as "ABCD EFG"

"ABC DEFGH" should appear as "ABCDE FGH" etc

How can i do this using string functions. Pls help. Thanks