Write a query to retrive partial string.
- 2 Answers
- 4720 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 rename a table in DB2 ?
What is rct?
What is check constraint in db2?
How do you insert a record with a nullable column?
Define db2.
can we drop column from a table
What is a root page?
What are the Isolation levels possible ?
what is cursor stability?
How does coalesce work?
How to define the data items to receive the fetch items for the SQL?
What is a synonym ?
COBOL 
