By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | LoginId |
|---|---|
| 1 | Tata-Motors\Harry9 |
| 2 | Orian-Analytics\Kartik10 |
| 3 | adventure-works\Rajashree3 |
| 4 | Team24\include324 |
| 5 | Team24\nonum |
| 6 | Alpha\nonum |
| 7 | Beta\123 |
| 8 | Gamma\ |
| 8 | xyz |
| id | LoginId | part_1 | part_2 | part_3 | part1_2 |
|---|---|---|---|---|---|
| 1 | Tata-Motors\Harry9 | Tata-Motors\ | Harry | 9 | Tata-Motors\Harry |
| 2 | Orian-Analytics\Kartik10 | Orian-Analytics\ | Kartik | 10 | Orian-Analytics\Kartik |
| 3 | adventure-works\Rajashree3 | adventure-works\ | Rajashree | 3 | adventure-works\Rajashree |
| 4 | Team24\include324 | Team24\ | include | 324 | Team24\include |
| 5 | Team24\nonum | Team24\ | nonum | Team24\nonum | |
| 6 | Alpha\nonum | Alpha\ | nonum | Alpha\nonum | |
| 7 | Beta\123 | Beta\ | 123 | Beta\ | |
| 8 | Gamma\ | Gamma\ | Gamma\ | ||
| 8 | xyz | xyz | xyz |
Msg 537 Level 16 State 2 Line 1
Invalid length parameter passed to the LEFT or SUBSTRING function.