0 - 3 of 3 tags for compare

 

Greetings All,

 

When comparing 2 different char/varchar datatypes in TD , the comparison is returning undesired results as the hexadecimal representation of the data in columns is different eventhough the data is visibly same.  Not sure what the "00" in the 

hexadecimal notation represents.  

 

 

Greetings All,

 

When comparing 2 different char/varchar datatypes in TD , the comparison is returning undesired results as the hexadecimal representation of the data in columns is different eventhough the data is visibly same.  Not sure what the "00" in the 

hexadecimal notation represents. 

 

Is there a Teradata way of doing the JARO_WINKLER_SIMILARITY Function that Oracle has?
http://docs.oracle.com/cd/E14072_01/appdev.112/e10577/u_match.htm
JARO_WINKLER_SIMILARITY Function