jdebill
Active Member
Hi All,
I was trying to set a filter on PTC on a view of the F4201 table to data select on = 03, 14, and AA. It didn't work as the SQL statement looked like it was a series of "PTC = "03" AND PTC = "14" AND PTC = "AA" so no records were returned. So how do you filter for a set of specific values like this?
Any help will be appreciated.
Thanks in Advance,
Thank You,
Bill
Windows NT, SQL 7, XE 13.0
I was trying to set a filter on PTC on a view of the F4201 table to data select on = 03, 14, and AA. It didn't work as the SQL statement looked like it was a series of "PTC = "03" AND PTC = "14" AND PTC = "AA" so no records were returned. So how do you filter for a set of specific values like this?
Any help will be appreciated.
Thanks in Advance,
Thank You,
Bill
Windows NT, SQL 7, XE 13.0