How is the SUBSTR keyword used in sql?
- 1 Answers
- 8533 Views
- I also Faced
- E-Mail Answers
How is the SUBSTR keyword used in sql?..
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 |
More DB2 Interview Questions
what is SPUFI ?
What is QUIESCE?
What are the advantages of using a PACKAGE?
What is the maximum length of sqlca?
What is iseries database?
What is sqlca?
what is the maximum number of tables that can be joined ?
What is an asychronous write?
What are column-name qualifiers used?
what happend with out using Commit,when closing cursor and program?
How do you filter out the rows retrieved from a Db2 table ?
Which catalog tables contain authorization information?
COBOL 
