[SQL] Separating by SQL unrecognized character

I am using MSSQL. A certain column is returning entries in the following format:

string1□string2□□□string3□string4□

I do not know what this character □ stands for, but I want the query to return string1 on a column and string2 on the next column, right next to it and to skip the rest so I can add other columns to the query.

For the sake of definition: | ID | text | | -------- | ---------------------- | | 1 | string1a□string2a□□□string3a□string4a□ | | 2 | string1b□string2b□□□string3b□string4b□ |

Result desired

ID string1 string2
1 string1a string2a
2 string1b string2b

example

Continue reading...