Archives of the TeradataForum

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

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

'%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>>