select substr(task_number,-2) from pa

how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE,
Its some urgent requirement ,thanks in advance

Question Posted / anju hajela

6 Answers
10642 Views
I also Faced
E-Mail Answers

Answer Posted / anju hajela

select substr(task_number,-2) from pa_task;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are reports usually used for?

1085

How do you rank data in sql?

1069

How do you break a loop in pl sql?

1103

Why stored procedures are faster than query?

1079

Are subqueries better than joins?

1041

What are all the ddl commands?

1244

What is a schema? How is it useful in sql servers?

1178

what is the syntax for using sql_variant_property? : Transact sql

1086

How do sql triggers work?

1096

How does a covering index work?

1011

How does postgresql compare to "nosql"?

1086

What are the parts of a sql statement?

1147

What is partition by in sql?

1132

What is Histogram?

1611

What are sql triggers used for?

1035