1. How do I just the last 4 digits only instead of the front digit?

--Look at the SalesOrderHeader table. Return the last group of digits out from AccountNumber column. Select RIGHT(AccountNumber,4) as AccountNumber From [Sales].[SalesOrderHeader];

--Use a different string manipulation function. Select LEN(AccountNumber) as AccountNumber From [Sales].[SalesOrderHeader];

--Use a different string manipulation function. Select Reverse (AccountNumber) as AccountNumber From [Sales].[SalesOrderHeader];

Is everything correct?