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

Question

Hi,

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 SUBSTRING(companyname, 3, len(companyname) - 2) FROM companies

Answer 2

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

Answer 3

Here is a bunch of string manipulation stuff for sql

Tutorial 4: SQL functions

Answer 4

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

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

Answer 5

SELECT SUBSTR(COMPANYNAME,3) FROM COMPANIES;