| # | Date | Forum | Type | Thread | Post |
|---|
| 4 | 26 Feb 2016 @ 08:13 PST | Database | Reply | How 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 ... |
| 3 | 21 Jul 2014 @ 08:38 PDT | Database | Reply | String Search in Teradata CLOB | The 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', &... |
| 2 | 24 Oct 2012 @ 03:01 PDT | Analytics | Reply | Transposing Data | Thanks for the SAS code.
|
| 1 | 14 Sep 2009 @ 03:36 PDT | Database | Reply | Teradata IDENTITY columns | On 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... |
|
|