how to truncate to the left

[trafford69]

how do i substr/truncate to the left if more than 9 characters in progress

 

[mrobles]

x = SUBSTRING(variable, 1, 9)