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
10726 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

how to start mysql server? : Sql dba

1260

Can delete statement be rollbacked?

1050

how to escape special characters in sql statements? : Sql dba

1110

If a cursor is open, how can we find in a pl/sql block?

1235

how to use regular expression in pattern match conditions? : Sql dba

1105

Can we rollback truncate?

1072

What is the best sql course?

1046

What is the current version of postgresql?

1170

how many tables will create when we create table, what are they? : Sql dba

1140

define sql insert statement ? : Sql dba

1094

what is sql server agent? : Sql dba

1179

Does group by remove duplicates?

1112

Can we use distinct and group by together?

1131

Do we need to rebuild index after truncate?

1130

what is collation? : Sql dba

1225