Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
- 1 Answers
- 8690 Views
- I also Faced
- E-Mail Answers
Answer / s
DIGITS will convert INTEGER to character string
SUBSTR(DIGITS(PARTID),5,1) ='9'
This will extract the 5th character and checks to see if it
is 9.
| Is This Answer Correct ? | 4 Yes | 0 No |
What's The Error Code For Unique Index Voilation?
What is meant by a unit of recovery?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the difference between drop table and delete table?
What is the use of with ur in db2?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
what is the input to PLAN? what is the input to DBRM?
What is EXPLAIN?
What is a collection?
What is bind and rebind in db2?
How do I optimize a query in db2?
What is the clustering index in the db2 database?
COBOL 
