scripts/LJCOPY/CCB/CCB_TRIM_SCRIPT/CCB_TRIM_SRCH_CHAR_VAL.sql

UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'0000000000' AND '0999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'1000000000' AND '1999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'2000000000' AND '2999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'3000000000' AND '3999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'4000000000' AND '4999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'5000000000' AND '5999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'6000000000' AND '6999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'7000000000' AND '7999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'8000000000' AND '8999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ACCT_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ACCT_ID                        BETWEEN            
'9000000000' AND '9999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'0000000000' AND '0999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'1000000000' AND '1999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'2000000000' AND '2999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'3000000000' AND '3999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'4000000000' AND '4999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'5000000000' AND '5999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'6000000000' AND '6999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'7000000000' AND '7999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'8000000000' AND '8999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_ITEM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.ITEM_ID                        BETWEEN            
'9000000000' AND '9999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'0000000000' AND '0999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'1000000000' AND '1999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'2000000000' AND '2999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'3000000000' AND '3999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'4000000000' AND '4999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'5000000000' AND '5999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'6000000000' AND '6999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'7000000000' AND '7999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'8000000000' AND '8999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_MTR_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.MTR_ID                         BETWEEN            
'9000000000' AND '9999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'0000000000' AND '0999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'1000000000' AND '1999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'2000000000' AND '2999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'3000000000' AND '3999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'4000000000' AND '4999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'5000000000' AND '5999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'6000000000' AND '6999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'7000000000' AND '7999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'8000000000' AND '8999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PREM_CHAR                   A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PREM_ID                        BETWEEN            
'9000000000' AND '9999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'0000000000' AND '0999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'1000000000' AND '1999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'2000000000' AND '2999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'3000000000' AND '3999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'4000000000' AND '4999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'5000000000' AND '5999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'6000000000' AND '6999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'7000000000' AND '7999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'8000000000' AND '8999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_PER_CHAR                    A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.PER_ID                         BETWEEN            
'9000000000' AND '9999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'0000000000' AND '0999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'1000000000' AND '1999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'2000000000' AND '2999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'3000000000' AND '3999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'4000000000' AND '4999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'5000000000' AND '5999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'6000000000' AND '6999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'7000000000' AND '7999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'8000000000' AND '8999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_CC_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.CC_ID                          BETWEEN            
'9000000000' AND '9999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'0000000000' AND '0999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'1000000000' AND '1999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'2000000000' AND '2999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'3000000000' AND '3999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'4000000000' AND '4999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'5000000000' AND '5999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'6000000000' AND '6999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'7000000000' AND '7999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'8000000000' AND '8999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
UPDATE CI_SP_CHAR                     A SET A.SRCH_CHAR_VAL =                   
TRIM(A.SRCH_CHAR_VAL) WHERE A.SP_ID                          BETWEEN            
'9000000000' AND '9999999999' AND TRIM(A.SRCH_CHAR_VAL) IS NOT NULL;            
COMMIT;                                                                         

                                                                              
EXIT;