Mike Hughes
Registered User.
- Local time
- Today, 10:28
- Joined
- Mar 23, 2002
- Messages
- 493
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 tell me if this can be done and how to do it?
SELECT
NOLDBA_INT_CASE_STATUS.CASE_ID,
NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE,
NOLDBA_INT_CASE_STATUS.CASE_TYPE,
NOLDBA_INT_CASE_STATUS.ESTABLISH_TYPE INTO [TABLE 1]
FROM NOLDBA_INT_CASE_STATUS
WHERE (((NOLDBA_INT_CASE_STATUS.CASE_STATUS)="O"))
ORDER BY NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE;
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 tell me if this can be done and how to do it?
SELECT
NOLDBA_INT_CASE_STATUS.CASE_ID,
NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE,
NOLDBA_INT_CASE_STATUS.CASE_TYPE,
NOLDBA_INT_CASE_STATUS.ESTABLISH_TYPE INTO [TABLE 1]
FROM NOLDBA_INT_CASE_STATUS
WHERE (((NOLDBA_INT_CASE_STATUS.CASE_STATUS)="O"))
ORDER BY NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE;
