Do we have any optinon to search part of integer in DB2 as
we have for character Like,SUBSTR optins?
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
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are db2 objects?
What do you mean by rollback?
what is a corelated subquerry?
What is the reason behind not using select * in embedded sql programs?
Why cursor is used in db2?
What is copy pending and check pending in db2?
What is collection in db2 bind?
What is an instance in db2?
How many types of page locks can be held in db2?
When do you specify the isolation level?
What is db2 instance?
What is universal database?
What is the difference between db2 and oracle?
What are the rules for db2 programming?