Archives of the TeradataForum

Message Posted: Sat, 19 May 2007 @ 22:39:12 GMT

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

I have a field with first name, middle initial and last name. Does anyone have any code that I can use to extract out each part of the name to insert into different fields? The names in the field are separated by space and a middle initial isn't always provided. The current name field in the staging table that contains the data is CHAR(65).

Thanks

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