Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to retrive partial string.
- 2 Answers
- 5671 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh_m13
substr('string',1,3) which gives str. correct me if i am wrong
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ignatius pradeep
A Sample Query:
SELECT SUBSTR(DESC_T,1,4)
FROM PRODUCT
WHERE PROD_I = 123456;
DESC_T is a column in the table PRODUCT
The first four characters of the DESC_T will be displayed.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is dclgen (declaration generator)?
What is the use of commit in db2?
How to define the a field which accepts value till 99999.99 in db2
What is the significance of DB2 free space and what parameters control it?
What is a db2 cursor?
What is cloudant database?
How can you get the number of rows impacted by the last executed query?
Is db2 a mainframe?
How can you count the number of rows from a table tab?
How connect db2 database to datastage?
How do you prepare a COBOL + DB2 program from coading till execution ?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
COBOL 
