#DateForumTypeThreadPost
426 Feb 2016 @ 08:13 PSTDatabaseReplyHow to calculate a character occurance in a string in teradata It's interesting to use a Regular Expression to solve the problem.  My query does more than the original question, and of course it could be eaisly simplified.   The query ...
321 Jul 2014 @ 08:38 PDTDatabaseReplyString Search in Teradata CLOBThe new Regular Expression functions like "REGEXP_INSTR" can search a CLOB. The example in the Teradata documentation is: SELECT REGEXP_INSTR('Hello Santa says ho ho', &...
224 Oct 2012 @ 03:01 PDTAnalyticsReplyTransposing DataThanks for the SAS code.
114 Sep 2009 @ 03:36 PDTDatabaseReplyTeradata IDENTITY columnsOn the same topic... I have a seemingly strange case where the Identity values skipped a large number of possible values. (1) Why did this happen and (2) what can be done to make it number sequent...