Phone Selection Formula problem

[grecon]

Need help with this selection formula:

{PHONES.CUST_NUM} = {?Pm-CUST.ID} and
{PHONES.PHONE_TYPE} in ["", "O"]

My problem is that it is not including the phone numbers that don't have a type. I need it to select the OFFICE phone number which is "O" and if it has no type listed I need it to select that. Thanks

 

[IanWaterman]

There is a world of difference between "" and NULL, you will probably find data is NULL. Try

{PHONES.CUST_NUM} = {?Pm-CUST.ID} and
(isnull({PHONES.PHONE_TYPE}) or {PHONES.PHONE_TYPE}= "O")

Ian