SQL/MP Query Guide

Hewlett-Packard Company—524488-003
i
HP NonStop SQL/MP Query
Guide
Index Examples Figures Tables
What’s New in This Manual xi
Manual Information xi
New and Changed Information xi
About This Manual xiii
Who Should Use This Manual? xiii
Prerequisites xiii
Organization xiii
Related Manuals xiv
Notation Conventions xvi
1. Retrieving Data: How to Write Queries
Using the SELECT Statement 1-2
Selecting Columns 1-3
Selecting Rows 1-4
Organizing Results 1-4
Specifying Search Conditions 1-8
Using the SELECT Statement in Programs 1-10
Using Null Values 1-14
Using String Functions
1-15
Extracting Part of a String
1-15
Searching for a String Within a String 1-17
Searching for a String Without Regard for its Case 1-18
Determining the Length of a String 1-18
Removing Leading or Trailing Characters From a String 1-19
Using the Concatenation Operator 1-20
Using Date-Time Columns 1-21
Accessing Date-Time Values 1-22
Specifying Date-Time Values in Programs 1-28
Defining Subqueries 1-28
Correlated Subqueries 1-29
Noncorrelated Subqueries 1-29