All Forums Database
carlsantos 4 posts Joined 11/09
20 Apr 2010
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:
Suma.Manu 15 posts Joined 11/09
20 Apr 2010

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 158 posts Joined 02/10
21 Apr 2010

what does CS meant for?

Suma.Manu 15 posts Joined 11/09
21 Apr 2010

CS stands for 'Case Specific'

carlsantos 4 posts Joined 11/09
21 Apr 2010

Thanks for the info.

You must sign in to leave a comment.