Oracle Sql

[chevyww1936]

I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex:

select ss_id from id_table

This will return all id's from this table and they are a length of 9 digits, i need to return just the last 6 so i can import them as student passwords. Any help would be appreciated. Thanks. Also i am using TOAD, and/or SQL Plus

[Sulley's Boo]

select substr(ss_id, 4, 6) from id_table

http://www.1keydata.com/sql/sql-substring.html

[chevyww1936]

Thank you very much, that is exactly what i needed. This was the 3rd forum i tryed in a list from google and you are the first to get it right, and i also appreciate the link.

[ccerdeira]

Other method:

select substr(ss_id, -6) from id_table

I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex:

select ss_id from id_table

This will return all id's from this table and they are a length of 9 digits, i need to return just the last 6 so i can import them as student passwords. Any help would be appreciated. Thanks. Also i am using TOAD, and/or SQL Plus

[debasisdas]

select substr(ss_id, -6) from id_table

this should work for you