Archives of the TeradataForum

Message Posted: Fri, 15 Dec 2006 @ 18:48:53 GMT

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

I don't think we have these functions.

You could try using the below SQL construct.

     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"

Thanks,

Vinay Bagare

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