Hi

customerid number(6)
customertype char(1)


we have two different customers types(P,A).Some are only one customer type but some have both types.

customerid -- ctype
----------- -------
123 -p
234-A
234-P
345-A
888-A

how do i retreive only those who has both customertype values such as 234

Thanks