db2

Question

hi 

i need script in db2 

i declared a variable IN pcontact varchar(50)

my requirement is if i enter partial value[ex:npn11] i need to get records based on partial value else if i entered full values with comma

seperated[more than one value ex:npn1101,npn1102]

i need to get records how to achieve this

ex:

---

IF pcontact <> '' THEN

SET pcontact = UPPER ( pcontact ) ;

SET where column IN (' || TRIM ( pcontact ) || ')' ;

END IF ; this is what we r using in current system so i need to implement both partil as well as comma seperated

 

Thanks