Archives of the TeradataForum

Message Posted: Tue, 16 Jul 2013 @ 16:15:57 GMT

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

You could try something like

     CASE WHEN UPPER(colname) = LOWER(colname)
          THEN CASE WHEN CHARACTERS(TRIM(colname)) BETWEEN 1 AND 6
                    THEN 'Y'
                    ELSE 'N' END
          ELSE 'N' END   AS Six_Char_Numeric_IND

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