Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 09:46:39 GMT

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

Hello,

May be you can use

     SELECT SUBSTR('GoodMorning',1,Length('GoodMorning')-3);

i.e.,

     SELECT SUBSTR(Columnname,1,Length(Columnname)-3) from Db_name.Tbl_name;

Regards,

Minal

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