Drop unwanted character from query ex.25516 becomes 2551 1

[iteach2]

Gurus,

I have a table that stores numbers in the from of 25516 but for purposes of my query I wish to drop the 6 so that it only shows 2551 - how can I format my query to exlude that last number for showing in the query

 

[amrita418]

Try this:

Select substr(column_name, 1, length(column_name) - 1)
from   TableName

OR

Select rtrim(Column_Name, '6')
from   TableName

If the column is int/number then you need to use to_char to convert it to varchar first.

Regards,
AA

 

[iteach2]

Perfecto!