Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
- 1 Answers
- 8345 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum number of columns in a db2 table?
Mention the location where the output received from explain statement is stored.
What are the various isolation levels possible?
What is db2 instance?
Explain the contents that are a part of dclgen.
What types of tables are there in the db2 database?
Why db2 is called db2?
How do I delete a table in database?
What is the difference between cursor and select statement?
What is rebind in db2?
Can there be more than one cursor open for any program?
Define data page.
What is dpf in db2?
What is declare cursor?
How many databases are there?
