By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab
([d] varchar(55))
;
INSERT INTO tab
([d])
VALUES
('Przykładowy tekst: Tablet IPAD PRO 10.5" /HG LITE'),
('Czasami jest też: Tablet Samsung Galaxy S4 10" T530 /HG')
;
2 rows affected
select
reverse(left(reverse(left(d,patindex('%[''"]%',d)-1)),charindex(' ',reverse(left(d,patindex('%[''"]%',d)-1)))))
from tab
| (No column name) |
|---|
| 10.5 |
| 10 |