Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Dec 2005 @ 10:58:04 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: NULLS to Spaces
 
From:   Appou, Kavitha

Hi,

You can create a new table with same DDL and populate the table And while populating the table, use COALESCE in SELECT Query.

     INSERT INTO TABLEB
     SELECT
     Cola,
     COALESCE(colb,' '),
     COALESCE(colc,' '),
     Cold.....
     From TABLEA;

This is one method. There can be many other creative ideas also.


Thanks,

Kavitha.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023