Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 14:19:57 GMT

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

Hi Vonod,

Please use this.

     select
      name
     ,substr(name,position(' ' in name)+1,char(name)) name1
     ,substr(name,0,position(' ' in name)) as "firstname"
     ,substr(name1,0,position(' ' in name1)) as "middlename"
     ,substr(name1,position(' ' in name1),char( name1)) "lastname"

     from  DBNAME.test1

Thanks,

Mahesh

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