In SQl Sever the query would be: select substring (reverse(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 / samiksha

6 Answers
10205 Views
I also Faced
E-Mail Answers

Answer Posted / samiksha

In SQl Sever the query would be:

select substring (reverse(task_number),1, 2) from task

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different sql data types?

951

how is myisam table stored? : Sql dba

993

What is asqueryable?

902

what are the advantages of sql ? : Sql dba

997

What is Collation Sensitivity ? What are the various type ?

901

What are different types of triggers?

1021

How do you explain an index?

1221

What is a left join?

884

how do you control the max size of a heap table? : Sql dba

918

Define commit, rollback and savepoint?

976

What is row_number () in sql?

928

Which normal form is best?

895

What are predefined functions in sql?

976

What do you understand by pl/sql cursors?

1011

How is use pl and sql?

997