Archives of the TeradataForum

Message Posted: Fri, 15 Dec 2006 @ 19:19:21 GMT

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

          > SEL
          > '1234M' AS sno -- CHAR type
          > ,CASE WHEN (UPPER(SUBSTRING(TRIM(sno) FROM 1 FOR 4)) (CASESPECIFIC) =
          > LOWER(SUBSTRING(TRIM(sno) FROM 1 FOR 4)) (CASESPECIFIC) ) AND
          > SUBSTRING(sno FROM 5 FOR 1) = 'M'
          > THEN 'MATCH' ELSE 'Mis MATCH' END AS "Result"

Oops. The fight with UPPER vs. LOWER is not over yet.

Victor

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