SQL get part of string, extract text within string using RIGHT, LEFT, LEN, SUBSTRING, CHARINDEX

[@Icanhasmovies]

so underrated how valuable this information is! Thank you for this.