ODBC and JDBC Guide

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 11

Table Of Contents

52 FileMaker ODBC and JDBC Guide

SELECT SUBSTR(Salespeople.Salesperson_ID, 2) +

SUBSTR(Salespeople.Salesperson_ID, 4) AS agg FROM Salespeople

SELECT SPACE(2) + Salespeople.Salesperson_ID AS Salesperson_ID FROM

Salespeople

SELECT STRVAL('60506') AS agg FROM Sales_Data WHERE Sales_Data.Invoice = 1