what is returned when you UNION both values?
SELECT value, char2hexint(value) FROM tableA a WHERE value='abc123'
SELECT value, char2hexint(value) FROM tableB b WHERE value='abc123'
That does work! What could be the difference between 'abc123' and 'abc123' that is stored in a teradata table?
"does work" is almost as good as "doesn't work" :-)
What is returned by that query? One row or two rows? And for UNION ALL?
Can you show the actual output?
Btw, you never need to join on TRIM(TRAILING) as string comparison does't care about trailing blanks. But a leading blank would matter, you might try TRIM(BOTH) instead.
One row is returned. Here is the output:
3230376239303736313430306135663134343037343536376662616333623037 again it's a 32 varchar string I'm trying to match up.
thanks for the tip about trim.
so you're searching for '207b90761400a5f144074567fbac3b07'?
And this exists in both tables? For 100% shure?
In the beginning i thought there might have been '20'xb and '80xb', space and no-break space, or non-printing chars which look the same, but these are only latin chars and digits.
You might open an incident.
thanks for the quick reply. yes, I am searching for
I'm sure (or as sure as can be) b/c when I search for the string (ie select * from tablea where val=
i get back a result.
If it exists in both tables following SQL should return exactly one row:
select * from
(select val from tablea where val= '207b90761400a5f144074567fbac3b07') as a
(select val from tableb where val= '207b90761400a5f144074567fbac3b07') as b
on a.val = b.val
Could you share the column definitions from the table? I'm wondering about differences in character set, upper/lower case attributes,...