By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT '931078027 BP 16:20:0:13 25 BAG ''B'' CLASS' AS val
)
SELECT val,
SUBSTRING(val,
CHARINDEX(' ', val) + 1,
LEN(val) - CHARINDEX(' ', val)) AS val_out
FROM yourTable;
| val | val_out |
|---|---|
| 931078027 BP 16:20:0:13 25 BAG 'B' CLASS | BP 16:20:0:13 25 BAG 'B' CLASS |