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


Please Help Members By Posting Answers For Below Questions

Which command is used to connect to a database in DB2 ? Give the Syntax.

845


What are db2 objects?

837


What do you mean by rollback?

761


what is a corelated subquerry?

839


What is the reason behind not using select * in embedded sql programs?

856


Why cursor is used in db2?

774


What is copy pending and check pending in db2?

758


What is collection in db2 bind?

781


What is an instance in db2?

780


How many types of page locks can be held in db2?

822


When do you specify the isolation level?

801


What is db2 instance?

816


What is universal database?

845


What is the difference between db2 and oracle?

884


What are the rules for db2 programming?

870