SQL intercepts the number of floors from the room number or from a string containing several "-" intervals, or intercepts the first few characters or numbers after the first few "-"

Code (room number)

Code

1-1-101

1-5-502

15-3-2001

According to the code room number of the intercepted floor for

Floor

1

5

20

SELECT case when Len (Code, CHARINDEX ('-', REVERSE (Code))-1))
= 3 then Left (code, CHARINDEX ('-', REVERSE (Code))-1), 1)
ELSE Left (code, CHARINDEX ('-', REVERSE (codename))-1), 2) END as Floor, *
From [00 Tao ran 16]

Right (codename, CHARINDEX ('-'), REVERSE (code name))-1) to intercept the third, that is, to intercept the last string, which is the final '-', if the length is 3, the first character is the floor, and if the length is 4, the top 2 characters are the floor.

SQL intercepts the number of floors from the room number or from a string containing several "-" intervals, or intercepts the first few characters or numbers after the first few "-"