By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @str varchar(100)= '****_xxx.$$$$.20210909_&&&'
select left(parsename(@str,1), 8) desired_substring
| desired_substring |
|---|
| 20210909 |
| desired_substring |
|---|
| 20210909 |