Create table PA_TASKS ( TASK_NUMBER nvarchar (30)) Insert into 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 / sumathy

6 Answers
10511 Views
I also Faced
E-Mail Answers

Answer Posted / sumathy

Create table PA_TASKS ( TASK_NUMBER nvarchar (30))

Insert into PA_TASKS values ('1.1.3NN')
Insert into PA_TASKS values ('1.1.4NN')
Insert into PA_TASKS values ('1.5.1NN')
Insert into PA_TASKS values ('1.3.2NE')
Insert into PA_TASKS values ('1.5NN')
Insert into PA_TASKS values ('1NN')
Insert into PA_TASKS values ('1.2NE')
Insert into PA_TASKS values ('1CE')

Select reverse( substring(reverse (TASK_NUMBER),1,2)) from
PA_TASKS

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to convert comma separated string to array in pl/sql?

1198

What's the difference between inner join and left join?

1011

What is sql rowcount?

1037

Mention what is the use of function "module procedure" in pl/sql?

1058

Why left join is used in sql?

989

Explain architecture of sql server notification services?

1070

How do I count records in sql?

1018

What is microsoft t sql?

951

How to pipe multiline string to isql?

1014

What is the difference between sql and mysql?

1129

What are the two characteristics of a primary key?

995

What are the usages of sql?

1065

what is top in tsql? : Transact sql

1136

What is the use of desc in sql?

988

What is varchar data type in sql?

1090