by using sub_str fuction we can do this select sub_str(task

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 / chandu

6 Answers
10725 Views
I also Faced
E-Mail Answers

Answer Posted / chandu

by using sub_str fuction we can do this

select sub_str(task_number,6) from pa_tasks.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is bcp? When does it used? : Sql dba

1053

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

1110

What is the current version of sql?

1091

What is the current version of postgresql?

1170

what is sql server agent? : Sql dba

1179

Can we use distinct and group by together?

1131

Can we rollback truncate?

1072

What is the best sql course?

1046

How do I remove duplicates in two columns?

1178

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

1235

Can delete statement be rollbacked?

1050

What is your daily office routine?

2340

Does group by remove duplicates?

1112

what is collation? : Sql dba

1225

what is dbms? : Sql dba

1061