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

Question

as stated in this section, I don’t want to return the first two letters of the returned values ​​just an example: select the company name from the companies returns companyX

Is it possible to write a query that returns panyX instead?

Thanks in advance

Answer 1

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

Answer 2

Since you are not saying which RDBMS you are using, here is the ANSI answer:

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

Answer 3

SELECT SUBSTRING (company name, 3, len (company name) - 2) FROM companies

Answer 4

Here is a bunch of sql row processing tools

Tutorial 4: SQL Functions

Answer 5

SELECT SUBSTR (COMPANY, 3) FROM COMPANIES;

Answer 6

u can solve the problem using the following queries,

  --> select substring([image],4,len([image]))from dbo.emp --> select replace([image],'ima','') from dbo.emp 

thanks

Venkat