Interested to Buy Any Domain ? << Click Here >> for more details...
How is the SUBSTR keyword used in sql?
- 1 Answers
- 9249 Views
- I also Faced
- E-Mail Answers
Answer / s
Select * from emp
where SUBSTR(empname,4,2) = 'EN'
4 is the starting position and returns 2 characters after
that.
| Is This Answer Correct ? | 8 Yes | 5 No |
What is the syntax required for the creation of a cursor?
What are iseries servers?
What r the comman abends in db2, jcl and cobol???????
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What are some characteristics of columns that benefit from indexes?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is usage pointer in cobol?
What is a db2 collection?
List some fields from sqlca?
What is the difference between static and dynamic SQL?
What is the difference between plan and package in db2?
COBOL 
