-Look at the SalesOrderHeader table. Return the last group of digits out from AccountNumber column.

Select REVERSE(LEFT(REVERSE(AccountNumber, 6)))

From [Sales].[SalesOrderHeader];

Select REVERSE(SUBSTR(REVERSE(AccountNumber, 1,6)) ) From [Sales].[SalesOrderHeader];

Both have the same problem the reverse function requires 1 argument(s).