421 Apr 2010 @ 09:23 PDTDatabaseReplyJoin On String Ignore CaseThanks for the info.
320 Apr 2010 @ 06:03 PDTDatabaseTopicJoin On String Ignore CaseHi, 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
218 Nov 2009 @ 02:29 PSTDatabaseReplySelect Month Date in GermanThanks for the workaround!
117 Nov 2009 @ 02:01 PSTDatabaseTopicSelect Month Date in GermanHi,I have this query in teradata:select current_date (format 'dd.bmmmmbyyyy') (varchar(30));with this output:17. November 2009Does anyone know how to convert the Month into German?