Join On String Ignore Case

Database

Join On String Ignore Case

Hi,

Does anyone know of a better way to do a table join on a string ignoring the case other than doing something like:

join on lower(a.str_col) = lower(b.str_col)

Thanks,
Carl
Tags (1)
4 REPLIES
Enthusiast

Re: Join On String Ignore Case

Hi,

Teradata default mode for character comparison is non case specific and the storage will be done as entered.

If Case specific comparison is needed
join on a.str_col(CS) = b.str_col(CS)
can be used.
WAQ
Enthusiast

Re: Join On String Ignore Case

what does CS meant for?
Enthusiast

Re: Join On String Ignore Case

CS stands for 'Case Specific'

Re: Join On String Ignore Case

Thanks for the info.