Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10726 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
What is the current version of sql?
what is sql server agent? : Sql dba
define sql insert statement ? : Sql dba
Is inner join faster than left join?
What is the current version of postgresql?
What is the best sql course?
how to start mysql server? : Sql dba
what is collation? : Sql dba
what is bcp? When does it used? : Sql dba
what are the advantages of sql ? : Sql dba
What is your daily office routine?
what are all the common sql function? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
what are aggregate and scalar functions? : Sql dba
how to escape special characters in sql statements? : Sql dba
