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

How many sql commands are there?

1159

How does sql profiler work?

1065

What is a mutating table and a constraining table?

1178

Can we create table inside stored procedure?

1016

What is fmtonly in sql?

1165

what are tables and fields? : Sql dba

1105

what is 'mysqlimport'? : Sql dba

1115

what is the difference between char_length and length? : Sql dba

1117

what does the t-sql command ident_current does? : Transact sql

1048

how to analyze tables with 'mysqlcheck'? : Sql dba

1062

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1896

How can you fetch common records from two tables?

1106

What is difference between sql function and stored procedure?

1063

what is a join? : Sql dba

1085

List the ways to get the count of records in a table?

943