This query, among other things, returns CASE_TYPE. One of the case types is being returned as “X” which is a valid case type.
What I want to do either in this query on in a query based on TABLE 1 ,created here, is to change all CASE_TYPE “X” returned to CASE_TYPE “N”. Could someone please...