Seleccionar substring entre dos strings conocidos, Sql Server

Seleccionar substring entre dos strings conocidos

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 11, rows affected: 11, absolute service time: 0,17 sec

edit mode | history

  
DESCRIPTION
Resultado

1
ID=123444,CATEGORY=ABC,OTRO=####
ABC

2
ID=123444,CATEGORY=ABCDEF,OTRO=####,MAS=GHIJK
ABCDEF

3
ID=123444,CATEGORY=A B C D E F,OTRO=####
A B C D E F

4
ID=123444,CATEGORY=,OTRO=####


5
ID=123444,CATEGORY=ABC
ABC

6
ID=123444,CATEGORY=ABCDEF
ABCDEF

7
ID=123444,CATEGORY=


8
CATEGORY=ABC,OTRO=####
ABC

9
CATEGORY=


10
ID=123444,OTRO=####


11
ABCDEF

λ

                                      .NET NoSQL database for rapid development