Write a query to retrive partial string.
- 2 Answers
- 4938 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 |
How to check sequence on a table in db2?
What is declare cursor?
Name the various locking levels available?
What is the significance of DB2 free space and what parameters control it?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
what types of copies can be made with the COPY Utility ?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
How do I connect my db2 database to ibm?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Request to database but database is not available so what is was abend is raised?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
COBOL 
