Archives of the TeradataForum

Message Posted: Fri, 16 Aug 2002 @ 20:19:46 GMT

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

Try this:

INSERT INTO NEWTABLE
( SUBSTRFLD)
SELECT
(CASE
WHEN SUBSTR(WHOLEFLD,4,1) IN ('N','S') THEN SUBSTR(WHOLEFLD,4,1)
ELSE NULL
END)AS SUBSTRFLD
FROM OLDTABLE;

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