Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Nov 2012 @ 11:53:56 GMT


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


Subj:   Re: What is the use of LIKE operator for char fields
 
From:   narayan.murthy

'%a' is anything that ends with 'a'. But 'jeeva' when stored in a char(20) field doesn't end with an 'a'. It is stored as 'jeeva' followed by spaces.

Perhaps if you were to try '%a%' it would work - i.e 'a' anywhere in between.

If the field where to be a varchar field, then only 'jeeva' would be stored , in which case '%a' would work.


Narayan
Teradata Certified
Wipro



     
  <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