Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Mar 2006 @ 15:56:02 GMT


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


Subj:   Re: Trimming Spaces Between Charachter
 
From:   Mohommod.Khan

I have not followed all the notes related to this topic , so excuse me if I am repeating any thing. Muktar, it sounds like a Stored Procedure is what you need. If you are able to create one then you can check the length of every record on the field that you are working using CHAR_LENGTH function. Now Trim you spaces by looking for ' ' and loop through your length.

Hope this helps.



     
  <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