'How to get and delete the some character between string in MSSQL?
I have start and end characters, but I didn't know what is the middle, middle is vary for every time. The start and end characters are constant.
for example,
some boys are there; some girls are there; somebody there;
This is the one example string, we have some as the 1st character and ; as the last character. The middle of the character is randomly changed in every cell, that doesn't need so I want to delete.
We have to try to get like this 'somebody there;'
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|