Skip first letters of all values returned from a sql server database

Question

as topic says, I don't want to return the first two letters in the return values just an example: select companyname from companies returns companyX

Can I write a query that returns panyX instead?

Thanks in advance

Answer 1

select right(companyname, len(companyname)-3) as companyname will do the thing (this should work for microsoft T-SQ, see more string functions here )

Answer 2

Since you don't say what RDBMS you're using, here is an ANSI-compliant answer:

SELECT SUBSTRING(mycolumn,3,CHARACTER_LENGTH(mycolumn))