Teradata Tutorial
Teradata Basics
Teradata Advanced
Teradata Useful Resources
Selected Reading
Teradata Basics
- Teradata - SubQueries
- Teradata - Joins
- Teradata - Primary Index
- Teradata - CASE & COALESCE
- Teradata - Aggregate Functions
- Teradata - Built-in Functions
- Teradata - Date/Time Functions
- Teradata - String Manipulation
- Teradata - SET Operators
- Logical & Conditional Operators
- Teradata - SELECT Statement
- Teradata - Data Manipulation
- Teradata - Tables
- Teradata - Data Types
- Teradata - Relational Concepts
- Teradata - Architecture
- Teradata - Installation
- Teradata - Introduction
Teradata Advanced
- Teradata - BTEQ
- Teradata - FastExport
- Teradata - MultiLoad
- Teradata - FastLoad
- Teradata - Performance Tuning
- Teradata - User Management
- Teradata - Data Protection
- Teradata - OLAP Functions
- Teradata - Partitioned Primary Index
- Teradata - JOIN Strategies
- Teradata - Stored Procedure
- Teradata - Macros
- Teradata - Views
- Teradata - Join Index
- Teradata - Hashing Algorithm
- Teradata - Explain
- Teradata - Compression
- Teradata - Statistics
- Teradata - Secondary Index
- Teradata - Space Concepts
- Teradata - Table Types
Teradata Useful Resources
- Teradata - Discussion
- Teradata - Useful Resources
- Teradata - Quick Guide
- Teradata - Questions & Answers
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Teradata - String Manipulation
Teradata - String Manipulation
Teradata provides several functions to manipulate the strings. These functions are compatible with ANSI standard.
| Sr.No | String Function & Description |
|---|---|
| 1 | || Concatenates strings together |
| 2 | SUBSTR Extracts a portion of a string (Teradata extension) |
| 3 | SUBSTRING Extracts a portion of a string (ANSI standard) |
| 4 | INDEX Locates the position of a character in a string (Teradata extension) |
| 5 | POSITION Locates the position of a character in a string (ANSI standard) |
| 6 | TRIM Trims blanks from a string |
| 7 | UPPER Converts a string to uppercase |
| 8 | LOWER Converts a string to lowercase |
Example
Following table psts some of the string functions with the results.
| String Function | Result |
|---|---|
| SELECT SUBSTRING(‘warehouse’ FROM 1 FOR 4) | ware |
| SELECT SUBSTR(‘warehouse’,1,4) | ware |
| SELECT ‘data’ || ‘ ‘ || ‘warehouse’ | data warehouse |
| SELECT UPPER(‘data’) | DATA |
| SELECT LOWER(‘DATA’) | data |