Claris FileMaker SQL Reference

https://help.claris.com/en/sql-reference/content/
Admin
Claris FileMaker SQL Reference documents the SQL statements, clauses, expressions, and functions...
Tokens:351,475
Snippets:1,431
Trust Score:10
Update:1 year ago
Show doc for...
Tokens:
Raw
### SQL LIKE Operator Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates how to search for a specified pattern in a column using the LIKE operator and wildcards. This example finds customer names starting with 'A'. It's useful for flexible text searching.

```sql
SELECT * FROM Customers
WHERE CustomerName LIKE 'A%';

```

--------------------------------

### SQL Wildcard _ Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of the '_' wildcard character with the SQL LIKE operator. It matches any single character.

```sql
SELECT * FROM customers
WHERE contactName LIKE '_r%'; -- Second character is 'r'

SELECT * FROM customers
WHERE country LIKE 'N__'; -- Starts with N and is three letters long
```

--------------------------------

### SQL Insert Statement Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of an SQL INSERT statement used to add new records to a table. It shows how to specify column names and their corresponding values.

```sql
INSERT INTO "Table" ("Field1", "Field2") VALUES ("Value1", "Value2")
```

--------------------------------

### SQL Select Statement Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Demonstrates a basic SQL SELECT statement to retrieve data from a table. This example illustrates selecting specific columns and applying a filter condition.

```sql
SELECT * FROM "Table" WHERE "Field" = "Value"
```

--------------------------------

### SQL INSERT Statement Example

Source: https://help.claris.com/en/sql-reference/content/field-names

Demonstrates how to insert new records into a database table using SQL. This example shows a basic INSERT statement, which is fundamental for data entry.

```sql
INSERT INTO Employees (EmployeeID, FirstName, LastName, HireDate)
VALUES (101, 'John', 'Doe', '2023-10-26');
```

--------------------------------

### SQL BETWEEN Operator Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows how to select values within a given range using the BETWEEN operator. This example retrieves products with prices between 10 and 50. It simplifies range-based filtering.

```sql
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 50;
```

--------------------------------

### SQL Date Functions (CURTIME)

Source: https://help.claris.com/en/sql-reference/content/relational-operators

Provides an example of the CURTIME() function to get the current time.

```sql
SELECT CURTIME();
```

--------------------------------

### SQL CREATE TABLE Statement Example

Source: https://help.claris.com/en/sql-reference/content/field-names

Demonstrates the syntax for creating a new table in a database. This statement defines the structure and columns of a new table.

```sql
CREATE TABLE Departments (
    DepartmentID INT PRIMARY KEY,
    DepartmentName VARCHAR(255) NOT NULL
);
```

--------------------------------

### SQL IS NOT NULL Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of the SQL IS NOT NULL operator, used to select rows where a column does not contain NULL values. Ensures data completeness.

```sql
SELECT * FROM customers
WHERE address IS NOT NULL;
```

--------------------------------

### SQL GRANT Permission Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows how to grant specific privileges to database users. This example grants SELECT and INSERT privileges on the 'Customers' table to a user named 'user1'. Permissions management is vital for database security.

```sql
GRANT SELECT, INSERT ON Customers TO user1;
```

--------------------------------

### SQL Subquery Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of a SQL subquery, which is a query nested inside another SQL query. Subqueries can be used in SELECT, FROM, WHERE, and HAVING clauses.

```sql
SELECT "Field" FROM "Table" WHERE "ID" IN (SELECT "ID" FROM "AnotherTable" WHERE "Status" = 'Active')
```

--------------------------------

### Claris SQL BETWEEN Operator Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Illustrates the use of the BETWEEN operator to select values within a given range. The range includes the start and end values.

```Claris SQL
SELECT * FROM Products WHERE price BETWEEN 50 AND 100;
```

--------------------------------

### Claris SQL CREATE TABLE Statement Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Demonstrates the creation of a new table in a Claris SQL database. It specifies column names, data types, and constraints.

```Claris SQL
CREATE TABLE Projects (
  projectID INT PRIMARY KEY,
  projectName VARCHAR(255),
  startDate DATE
);
```

--------------------------------

### SQL Delete Statement Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Presents an SQL DELETE statement to remove records from a table. The example demonstrates how to specify criteria for the records to be deleted.

```sql
DELETE FROM "Table" WHERE "Field" = "Value"
```

--------------------------------

### SQL Aggregate Function COUNT Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of the SQL COUNT aggregate function to determine the number of rows that match a specified criterion. Essential for data summarization.

```sql
SELECT COUNT(column_name)
FROM table_name;
```

--------------------------------

### SQL Wildcard % Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Illustrates the use of the '%' wildcard character with the SQL LIKE operator. It matches any sequence of characters.

```sql
SELECT * FROM customers
WHERE customerName LIKE 'A%'; -- Starts with A

SELECT * FROM customers
WHERE customerName LIKE '%a'; -- Ends with a

SELECT * FROM customers
WHERE customerName LIKE '%or%'; -- Contains 'or'
```

--------------------------------

### SQL ORDER BY Clause Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Demonstrates the SQL ORDER BY clause for sorting the result set in ascending or descending order. Crucial for presenting data logically.

```sql
SELECT * FROM table_name ORDER BY column_name ASC|DESC;
```

--------------------------------

### Claris SQL INSERT Statement Example

Source: https://help.claris.com/en/sql-reference/content/constants

Example of an INSERT statement in Claris SQL used to add new records to a table. This code specifies the table, the columns to populate, and the values for those columns. Adjust table and column names, as well as the data types of the values, to match your database.

```sql
INSERT INTO your_table_name (column1, column2, column3)
VALUES ('value1', 'value2', 123);
```

--------------------------------

### SQL WHERE Clause Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates the use of the WHERE clause to filter records based on a condition. This example selects customers from a specific city. It's crucial for targeted data retrieval.

```sql
SELECT * FROM Customers
WHERE City = 'London';
```

--------------------------------

### Claris SQL Date Formatting Example

Source: https://help.claris.com/en/sql-reference/content/constants

Example of formatting dates in Claris SQL using the `Format` function. This allows you to display date values in a specific string format. The format specifiers determine the output representation of the date.

```sql
SELECT Format(order_date, 'YYYY-MM-DD') AS formatted_date
FROM orders;
```

--------------------------------

### SQL CREATE TABLE Statement

Source: https://help.claris.com/en/sql-reference/content/create-index-statement

Provides an example of creating a new table with specified columns and their data types. It demonstrates defining column constraints like NOT NULL.

```sql
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
    ...
);
```

--------------------------------

### SQL Aggregate Function Examples

Source: https://help.claris.com/en/sql-reference/content/aggregate-functions

Provides examples of using SUM, AVG, COUNT, MAX, and MIN aggregate functions in SQL SELECT statements within Claris FileMaker.

```sql
SELECT SUM (Sales_Data.Amount) AS agg FROM Sales_Data
```

```sql
SELECT AVG (Sales_Data.Amount) AS agg FROM Sales_Data
```

```sql
SELECT COUNT (Sales_Data.Amount) AS agg FROM Sales_Data
```

```sql
SELECT MAX (Sales_Data.Amount) AS agg FROM Sales_Data WHERE Sales_Data.Amount < 3000
```

```sql
SELECT MIN (Sales_Data.Amount) AS agg FROM Sales_Data WHERE Sales_Data.Amount > 3000
```

--------------------------------

### Claris SQL LIKE Operator Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Demonstrates the use of the LIKE operator for pattern matching in string columns. Wildcards '%' and '_' are commonly used.

```Claris SQL
SELECT customerName FROM Customers WHERE customerName LIKE 'A%';
SELECT customerName FROM Customers WHERE customerName LIKE '_a%';

```

--------------------------------

### SQL CREATE INDEX Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates how to create an index on a table to speed up data retrieval operations. This example creates a unique index on the 'Email' column of the 'Customers' table. Indexes are crucial for database performance tuning.

```sql
CREATE UNIQUE INDEX idx_email ON Customers (Email);
```

--------------------------------

### SQL String Function - Concatenation Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Shows an example of SQL string concatenation to combine multiple text fields into a single string. This is useful for formatting output or creating composite keys.

```sql
SELECT "FirstName" || ' ' || "LastName" AS "FullName" FROM "Table"
```

--------------------------------

### SQL IN Operator Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates how to specify multiple values in a WHERE clause using the IN operator. This example selects customers from specific countries. It's a concise way to check for multiple possible values.

```sql
SELECT * FROM Customers
WHERE Country IN ('Germany', 'France', 'UK');
```

--------------------------------

### SQL WHERE Clause - Example

Source: https://help.claris.com/en/sql-reference/content/offset-and-fetch-first-clauses

Demonstrates the usage of the WHERE clause in SQL to filter records based on specific conditions. It shows how to select data that meets a particular criterion.

```sql
SELECT column1, column2, ...
FROM table_name
WHERE condition;
```

--------------------------------

### SQL HAVING Clause Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates how to filter groups based on a specified condition using the HAVING clause. This example shows cities with more than 5 customers. HAVING is used after GROUP BY to filter aggregated results.

```sql
SELECT City, COUNT(*) AS NumberOfCustomers
FROM Customers
GROUP BY City
HAVING COUNT(*) > 5;
```

--------------------------------

### Claris SQL: Date Functions (Example)

Source: https://help.claris.com/en/sql-reference/content/constants

Provides an example of using date-related functions in Claris SQL. This snippet might show how to extract parts of a date or perform date arithmetic. Specific functions depend on the Claris SQL dialect.

```sql
SELECT DATE('now'), STRFTIME('%Y-%m-%d', 'now');
```

--------------------------------

### SQL GROUP BY Clause Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates how to group rows that have the same values in specified columns into summary rows using the GROUP BY clause. This example counts the number of customers in each city. GROUP BY is often used with aggregate functions.

```sql
SELECT City, COUNT(*) AS NumberOfCustomers
FROM Customers
GROUP BY City;
```

--------------------------------

### SQL Date Function Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates the use of a common date function to retrieve the current date. This example selects all orders placed today. Date functions are essential for time-based data filtering and reporting.

```sql
SELECT * FROM Orders
WHERE OrderDate = CURDATE();
```

--------------------------------

### SQL Aggregate Function MIN Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Demonstrates the SQL MIN aggregate function for finding the smallest value in a column. Useful for identifying minimums in datasets.

```sql
SELECT MIN(column_name)
FROM table_name;
```

--------------------------------

### SQL ORDER BY Clause Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates how to sort the result set of a query in ascending or descending order using the ORDER BY clause. This example sorts customers by country. It's important for presenting data in a structured manner.

```sql
SELECT * FROM Customers
ORDER BY Country ASC;
```

--------------------------------

### SQL CREATE TABLE Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates the syntax for creating a new table in a SQL database. This snippet defines the table name and the columns with their respective data types and constraints. It's fundamental for database schema design.

```sql
CREATE TABLE Products (
    ProductID int PRIMARY KEY,
    ProductName varchar(255),
    Price decimal(10, 2)
);
```

--------------------------------

### SQL SELECT Statement Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Demonstrates a basic SQL SELECT statement to retrieve data from a table. This function is fundamental for querying databases.

```sql
SELECT customerName, city, country
FROM customers
WHERE country = 'Mexico';
```

--------------------------------

### SQL Query Example

Source: https://help.claris.com/en/sql-reference/content/field-names

A basic SQL query to select specific columns from a table. This demonstrates fundamental SELECT statement syntax.

```sql
SELECT column1, column2
FROM your_table_name
WHERE condition;
```

--------------------------------

### JavaScript Example for Claris SQL Interaction

Source: https://help.claris.com/en/sql-reference/content/truncate-table-statement

An example of how to interact with a Claris SQL database using JavaScript. This snippet outlines the basic structure for establishing a connection and executing a query. It typically involves a server-side component or a direct API integration. The function returns query results.

```javascript
async function getProducts(db) {
  const query = "SELECT ProductName, Price FROM Products";
  try {
    const results = await db.execute(query);
    return results;
  } catch (error) {
    console.error("Error executing query:", error);
    return null;
  }
}
```

--------------------------------

### SQL Data Types (Date and Time)

Source: https://help.claris.com/en/sql-reference/content/relational-operators

Examples of data types for storing date, time, and timestamp information.

```sql
CREATE TABLE example (
    date_column DATE,
    time_column TIME,
    timestamp_column TIMESTAMP
);
```

--------------------------------

### SQL INSERT INTO SELECT Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates how to insert data into a table from another table using a SELECT statement. This example copies data from an old table to a backup table. It's useful for data migration and archiving.

```sql
INSERT INTO CustomersBackup (CustomerName, City)
SELECT CustomerName, City FROM Customers WHERE Country = 'Germany';
```

--------------------------------

### SQL Function: CONCAT()

Source: https://help.claris.com/en/sql-reference/content/constants

Example of using the CONCAT() function in Claris SQL for joining two or more strings together.

```sql
SELECT CONCAT(string1, string2)
FROM table_name;
```

--------------------------------

### Claris SQL Substring Function Example

Source: https://help.claris.com/en/sql-reference/content/constants

This snippet shows how to extract a portion of a string using the Substring function in Claris SQL. It requires the string, starting position, and length of the substring to extract. Useful for parsing or manipulating text data.

```sql
SELECT Substring(product_code, 1, 3) AS product_prefix
FROM products;
```

--------------------------------

### SQL HAVING Clause Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of the SQL HAVING clause, used to filter groups based on a specified condition. It is typically used with GROUP BY.

```sql
SELECT COUNT(column_name), column_name
FROM table_name
WHERE condition
GROUP BY column_name
HAVING COUNT(column_name) > value;
```

--------------------------------

### SQL DDL - CREATE DATABASE

Source: https://help.claris.com/en/sql-reference/content/offset-and-fetch-first-clauses

Demonstrates the Data Definition Language (DDL) command CREATE DATABASE for creating a new database in the Claris environment.

```sql
CREATE DATABASE database_name;
```

--------------------------------

### SQL JOIN Clause Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows how to combine rows from two or more tables based on a related column between them using the JOIN clause. This example retrieves customer names and their corresponding order IDs. JOINs are essential for relational database querying.

```sql
SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
```

--------------------------------

### SQL SELECT Statement Example

Source: https://help.claris.com/en/sql-reference/content/field-names

Illustrates how to retrieve data from a database table using the SELECT statement. This is a core operation for querying and viewing data.

```sql
SELECT EmployeeID, FirstName, LastName
FROM Employees
WHERE HireDate >= '2023-01-01';
```

--------------------------------

### Claris SQL INSERT Statement Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Illustrates how to insert new records into a Claris SQL database table. It shows the syntax for providing values for columns.

```Claris SQL
INSERT INTO Products (productName, price) VALUES ("Gadget", 19.99);
```

--------------------------------

### SQL DELETE Statement Example

Source: https://help.claris.com/en/sql-reference/content/field-names

Provides an example of how to remove records from a database table using the DELETE statement. Use with caution as it permanently removes data.

```sql
DELETE FROM Employees
WHERE EmployeeID = 101;
```

--------------------------------

### CSS Responsive Layouts and Navigation

Source: https://help.claris.com/en/sql-reference/content/constants

Styles for multi-column layouts, ensuring responsiveness across different screen sizes. Includes rules for navigation items, hover effects, and margin adjustments for last-child elements.

```css
ation li:last-child,.ei-multicolumn .column-flex:last-child .ei-expand-local-nav,.ei-multicolumn .column:last-child .ei-expand-local-nav{margin-right:0}.ei-expand-local-nav{display:block;text-align:right;color:#208a3d;margin-bottom:24px;cursor:pointer}.column.tertiary-nav-item.selected:hover p,.ei-expand-local-nav:hover{color:#2da14a}@media only screen and (min-width:736px){.ei-multicolumn .column-flex .expandable-item{margin-top:-18px}}@media only screen and (max-width:735px){.ei-multicolumn{flex-direction:column}.ei-multicolumn .column-flex .column-content{padding-bottom:0}.column-flex:last-child .expandable-item,.column:last-child .expandable-item{margin-left:0;margin-right:0}.column .expandable-item,.column-flex .expandable-item{margin-left:0;margin-right:0}.ei-multicolumn .column .ei-expand-local-nav{margin-right:0}.ei-multicolumn .column:last-child h2,.ei-multicolumn .column:last-child h3,.ei-multicolumn .column:last-child h4{margin-left:0}}
```

--------------------------------

### Claris SQL: String Functions (Example)

Source: https://help.claris.com/en/sql-reference/content/constants

Shows an example of using string manipulation functions in Claris SQL. This might include functions for concatenation, finding substrings, or changing case. These are common for text data processing.

```sql
SELECT LENGTH('example string'), UPPER('example string');
```

--------------------------------

### SQL INSERT Statement Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Illustrates how to use the SQL INSERT statement to add new records into a table. This is a core operation for data management.

```sql
INSERT INTO customers (customerName, city, country)
VALUES ('Cardinal', 'Stavanger', 'Norway');
```

--------------------------------

### SQL IS NULL Example

Source: https://help.claris.com/en/sql-reference/content/select-statement

Shows how to use the IS NULL operator to test for empty values (NULL). This is important for identifying and handling records that lack specific data.

```sql
SELECT column_name(s)
FROM table_name
WHERE column_name IS NULL;
```

--------------------------------

### SQL UPDATE Statement Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of the SQL UPDATE statement, used to modify existing records within a table. Essential for data maintenance.

```sql
UPDATE customers
SET address = 'Valley 345'
WHERE customerName = 'Alfreds Futterkiste';
```

--------------------------------

### Claris SQL: LIKE Operator

Source: https://help.claris.com/en/sql-reference/content/constants

Illustrates the LIKE operator for pattern matching within string data. This example shows how to search for values that match a specific pattern using wildcards ('%' and '_'). Useful for flexible text searches.

```sql
SELECT column1, column2
FROM your_table_name
WHERE column1 LIKE 'pattern%';
```

--------------------------------

### SQL Comment Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates how to add comments to SQL code for better readability and explanation. Comments are ignored by the database engine but are crucial for code maintainability.

```sql
-- This is a single-line comment

/*
This is a multi-line
comment.
*/
SELECT * FROM Customers;
```

--------------------------------

### Claris SQL Subquery Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Provides an example of a subquery (nested query) used within another SQL query. Subqueries can be used in SELECT, FROM, WHERE, and HAVING clauses.

```Claris SQL
SELECT customerName FROM Customers WHERE customerID IN (SELECT customerID FROM Orders WHERE amount > 1000);
```

--------------------------------

### FileMaker SQL Syntax for SELECT Statements

Source: https://help.claris.com/en/sql-reference/content/constants

Demonstrates the basic structure of a SELECT statement in FileMaker SQL, including selecting columns, specifying tables, and applying WHERE clauses. This is fundamental for retrieving data.

```sql
SELECT column1, column2
FROM tablename
WHERE condition;
```

--------------------------------

### SQL CREATE TABLE Statement in Claris

Source: https://help.claris.com/en/sql-reference/content/sql-clauses

Demonstrates the syntax for creating a new table in Claris SQL. This involves defining the table name and its columns with their respective data types. Constraints and indexes are not detailed in this basic example. Ensure data types are appropriate for the intended data.

```SQL
CREATE TABLE TableName (
    column1 datatype,
    column2 datatype,
    ...
);
```

--------------------------------

### Claris SQL CREATE TABLE Statement

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of the CREATE TABLE statement used to define and create new tables within a Claris database. It includes specifying column names and their data types.

```sql
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    ... 
);
```

--------------------------------

### Claris SQL ORDER BY Clause Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Shows how to sort the result set of a query in ascending or descending order based on one or more columns.

```Claris SQL
SELECT productName, price FROM Products ORDER BY price DESC;
```

--------------------------------

### Script Loading (HTML)

Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects

This HTML snippet demonstrates how various JavaScript files are loaded asynchronously using the 'defer' attribute. It includes polyfills, jQuery, cookie-related scripts, and site-specific JavaScript. The 'defer' attribute ensures scripts are executed after the HTML document has been parsed, improving page load performance.

```html
<script defer src="/site/js/polyfill.js"></script>
<script defer src="/site/js/jquery.min.js"></script>
<script defer src="/site/js/jquery.cookie.js"></script>
<script defer src="/site/js/js-cookie/3.0.0/js.cookie.min.js"></script>
<script defer src="/site/js/sitewide_tail.js?v=10"></script>
<script defer src="/interactive/themes/beacon/localization-gr/js/gr.js?v=6"></script>
<script defer src="/site/js/chat.js?v=3"></script>
```

--------------------------------

### SQL UPDATE Statement Example

Source: https://help.claris.com/en/sql-reference/content/update-statement

An example of an SQL UPDATE statement modifying the salary and exempt status of an employee in the 'emp' table based on their employee ID.

```sql
UPDATE emp SET salary=32000, exempt=1 WHERE emp_id = 'E10001'
```

--------------------------------

### SQL INSERT Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates how to insert data into a table using SQL. This snippet typically involves specifying the table name and the values to be inserted. It's a fundamental operation for populating databases.

```sql
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Alfreds Futterkiste', 'Maria Anders', 'Obere Str. 57', 'Berlin', '12209', 'Germany');
```

--------------------------------

### Claris SQL UPDATE Statement Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Provides an example of updating existing records in a Claris SQL table. This is useful for modifying data based on specific criteria.

```Claris SQL
UPDATE Orders SET status = "Shipped" WHERE orderID = 12345;
```

--------------------------------

### SQL Data Types (Text)

Source: https://help.claris.com/en/sql-reference/content/relational-operators

Examples of common text-based data types used for storing character strings.

```sql
CREATE TABLE example (
    text_column VARCHAR(255),
    long_text_column TEXT
);
```

--------------------------------

### Claris SQL: CREATE TABLE Statement

Source: https://help.claris.com/en/sql-reference/content/constants

Demonstrates the SQL CREATE TABLE statement for defining a new table structure. This snippet outlines specifying the table name and its columns with their respective data types. This is fundamental for database schema design.

```sql
CREATE TABLE your_table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype
);
```

--------------------------------

### SQL Function: LENGTH()

Source: https://help.claris.com/en/sql-reference/content/constants

Example of using the LENGTH() function in Claris SQL to determine the length of a string.

```sql
SELECT LENGTH(string_column)
FROM table_name;
```

--------------------------------

### SQL Function: SUBSTRING()

Source: https://help.claris.com/en/sql-reference/content/constants

Illustrates the SUBSTRING() function in Claris SQL for extracting a part of a string, specifying the starting position and length.

```sql
SELECT SUBSTRING(string_column, start_position, length)
FROM table_name;
```

--------------------------------

### Claris SQL Aggregate Function Example (SUM)

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Shows the usage of the SUM aggregate function to calculate the total of a numeric column.

```Claris SQL
SELECT SUM(amount) FROM Payments WHERE paymentDate >= "2023-01-01";
```

--------------------------------

### SQL Aggregate Function AVG Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Shows an example of the SQL AVG aggregate function to compute the average value of a numeric column. Commonly used in statistical analysis.

```sql
SELECT AVG(column_name)
FROM table_name;
```

--------------------------------

### Inserting Data into a Table using Claris SQL

Source: https://help.claris.com/en/sql-reference/content/logical-operators

Example of an SQL INSERT statement to add a new record to a 'Products' table. The statement specifies values for 'ProductID', 'ProductName', and 'Price'.

```sql
INSERT INTO Products (ProductID, ProductName, Price) VALUES (101, 'Gadget', 19.99);
```

--------------------------------

### Claris SQL DROP TABLE Statement Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Shows how to remove a table from the database. This action is irreversible and should be used with caution.

```Claris SQL
DROP TABLE OldData;
```

--------------------------------

### JavaScript: Newsletter Pre-Signup Functionality

Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects

This JavaScript file, referenced by the 'defer' attribute, is responsible for pre-newsletter signup functionalities. The exact functions and their purpose are not detailed in the provided HTML, but it's loaded asynchronously to avoid blocking page rendering.

```javascript
defer type="text/javascript" src="/site/includes/email-signup/js/pre-newsletter.js?v=8"
```

--------------------------------

### Claris SQL ALTER TABLE Statement Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Illustrates modifying an existing table structure using the ALTER TABLE statement. This example adds a new column to a table.

```Claris SQL
ALTER TABLE Customers
ADD COLUMN email VARCHAR(255);
```

--------------------------------

### SQL String Function SUBSTRING()

Source: https://help.claris.com/en/sql-reference/content/where-clause

Illustrates the SQL SUBSTRING() function for extracting a part of a string. Specify the starting position and the length of the substring.

```sql
SELECT SUBSTRING(string_name, start_position, length);
```

--------------------------------

### SQL Update Statement Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Illustrates an SQL UPDATE statement for modifying existing records in a table. This example shows how to set new values for specific columns based on a condition.

```sql
UPDATE "Table" SET "Field" = "NewValue" WHERE "Field" = "OldValue"
```

--------------------------------

### SQL UPDATE Statement with Subquery Example

Source: https://help.claris.com/en/sql-reference/content/update-statement

An example of an SQL UPDATE statement that uses a subquery to set the salary of a specific employee to the average salary of all employees in the 'emp' table.

```sql
UPDATE emp SET salary = (SELECT avg(salary) from emp) WHERE emp_id = 'E10001'
```

--------------------------------

### SQL SELECT Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates how to retrieve data from a database table using the SELECT statement. This snippet shows basic selection of columns and specifying the table to query from. It's essential for data retrieval.

```sql
SELECT CustomerName, City FROM Customers;
```

--------------------------------

### SQL LIKE Operator Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Shows the SQL LIKE operator, used in a WHERE clause to search for a specified pattern in a column. It supports wildcard characters like % and _.

```sql
SELECT * FROM table_name
WHERE column_name LIKE pattern;
```

--------------------------------

### SQL INSERT INTO Statement - Adding Records

Source: https://help.claris.com/en/sql-reference/content/offset-and-fetch-first-clauses

Provides an example of the INSERT INTO statement for adding new rows of data into a database table. It covers specifying column values for the new record.

```sql
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
```

--------------------------------

### SQL Example: Filtering Groups with HAVING

Source: https://help.claris.com/en/sql-reference/content/having-clause

This example demonstrates how to use the HAVING clause to filter grouped records. It selects department IDs and the sum of salaries, displaying only those departments where the total salary exceeds $200,000.

```sql
SELECT dept_id, SUM (salary) FROM emp GROUP BY dept_id HAVING SUM (salary) > 200000
```

--------------------------------

### Claris SQL GROUP BY Clause Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Demonstrates how to group rows that have the same values in specified columns into a summary row, often used with aggregate functions.

```Claris SQL
SELECT department, COUNT(*) FROM Employees GROUP BY department;
```

--------------------------------

### SQL DEFAULT Constraint

Source: https://help.claris.com/en/sql-reference/content/where-clause

Provides an example of the SQL DEFAULT constraint, which inserts a default value into a column if no value is specified. Simplifies data entry.

```sql
CREATE TABLE table_name (
    column_name varchar(255) DEFAULT 'value'
);
```

--------------------------------

### Claris SQL Aggregate Function Example (COUNT)

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Illustrates the use of the COUNT aggregate function to count the number of rows that match a specified criterion.

```Claris SQL
SELECT COUNT(*) FROM Employees WHERE department = "Sales";
```

--------------------------------

### SQL Join Operation Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Demonstrates an SQL INNER JOIN operation to combine rows from two or more tables based on a related column between them. This example links two tables on a common field.

```sql
SELECT T1."Field1", T2."Field2" FROM "Table1" T1 INNER JOIN "Table2" T2 ON T1."CommonField" = T2."CommonField"
```

--------------------------------

### Modernizr Feature Detection and Configuration

Source: https://help.claris.com/en/sql-reference/content/index

This snippet initializes Modernizr, a JavaScript library used for detecting HTML5 and CSS3 features available in the user's browser. It includes tests for WebP image formats and CSS 'position: sticky', and manages asynchronous test loading.

```javascript
/*! Modernizr 3.6.0 (Custom Build) | MIT 
 * https://modernizr.com/download/?-csspositionsticky-webp 
 */
window.Modernizr = function(a, b, c) {
	function z(a, b) {
		var c = b.substr(0, b.indexOf(" "));
		return a.style[c] !== c.toLowerCase()
	}
	function y(a, b, d, e) {
		var f;
		try {
			f = b.createElement(a)
		} catch (g) {
			f = b.createEvent("Element");
			f.initEvent(a, !1, !1)
		}
		return "function" != typeof f.style.setProperty ? b.body || b.documentElement : (f.style.cssText = d, f)
	}
	function x(a, b) {
		return ("" + a).indexOf(b) \
	}
	function w(a, b) {
		return a.replace(/[^ ]+ /, "") \
	}
	function v(a, b, c, d) {
		var e, f, g, h, i = b.load;
		b.load = function() {
			// A crude async 
					event.preventDefault ? event.preventDefault() : event.returnValue = !1,
						"undefined" != typeof b.readyState ? b.readyState \
								: (b.style.display = "none", b.style.cssText = "", b.parentNode.removeChild(b))
					}
						
																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																														d																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																					
```

--------------------------------

### SQL REVOKE Permission Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates how to revoke previously granted privileges from database users. This example revokes the INSERT privilege on the 'Customers' table from 'user1'. Revoking permissions is essential for maintaining security.

```sql
REVOKE INSERT ON Customers FROM user1;
```

--------------------------------

### SQL CREATE TABLE Statement - Defining Tables

Source: https://help.claris.com/en/sql-reference/content/offset-and-fetch-first-clauses

Demonstrates the SQL CREATE TABLE statement used to define a new table in the database. It includes specifying column names, data types, and constraints.

```sql
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
    ....
);
```

--------------------------------

### Claris SQL: Rename Table Example

Source: https://help.claris.com/en/sql-reference/content/alter-table-statement

Example demonstrating how to rename an entire table using the ALTER TABLE statement in Claris SQL. This changes the identifier of the table within the database.

```sql
ALTER TABLE Salespeople RENAME TO Salesperson
```

--------------------------------

### SQL Query Example in Claris SQL

Source: https://help.claris.com/en/sql-reference/content/constants

This snippet demonstrates a basic SQL query to select data from a table in Claris SQL. It shows how to retrieve specific columns and filter rows based on certain criteria. Ensure the table and column names are correctly specified for your database schema.

```sql
SELECT column1, column2
FROM your_table_name
WHERE column1 = 'some_value';
```

--------------------------------

### SQL IS NULL Operator Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows how to check if a column contains NULL values using the IS NULL operator. This example finds customers without a specified region. It's important for handling missing data.

```sql
SELECT * FROM Customers
WHERE Region IS NULL;
```

--------------------------------

### Claris SQL: ORDER BY Clause

Source: https://help.claris.com/en/sql-reference/content/constants

Shows how to use the ORDER BY clause to sort the result set of a query in ascending or descending order. This example demonstrates sorting by one or more columns. It ensures data is presented in a structured manner.

```sql
SELECT column1, column2
FROM your_table_name
WHERE condition
ORDER BY column1 ASC, column2 DESC;
```

--------------------------------

### SQL CREATE TABLE with Constraints Example

Source: https://help.claris.com/en/sql-reference/content/where-clause

Illustrates creating a table with various constraints like NOT NULL, UNIQUE, PRIMARY KEY, and FOREIGN KEY. These enforce data integrity.

```sql
CREATE TABLE Persons (
    PersonID int NOT NULL PRIMARY KEY,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);
```

--------------------------------

### SQL ALTER TABLE Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates how to modify an existing table structure using the ALTER TABLE statement. This example shows adding a new column to a table. It's used for schema evolution.

```sql
ALTER TABLE Customers
ADD Email varchar(255);
```

--------------------------------

### SQL Syntax for Data Manipulation and Definition

Source: https://help.claris.com/en/sql-reference/content/where-clause

This snippet showcases fundamental SQL syntax for data manipulation (like SELECT, INSERT, UPDATE, DELETE) and data definition (like CREATE TABLE, ALTER TABLE, DROP TABLE). It is useful for understanding basic SQL operations and structures. No specific external dependencies are noted.

```sql
SELECT column1, column2 FROM table_name WHERE condition;
INSERT INTO table_name (column1, column2) VALUES (value1, value2);
UPDATE table_name SET column1 = value1 WHERE condition;
DELETE FROM table_name WHERE condition;
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    PRIMARY KEY (column1)
);
ALTER TABLE table_name
ADD column_name datatype;
DROP TABLE table_name;
```

--------------------------------

### SQL DELETE Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Provides an example of how to remove records from a database table using the DELETE statement. This snippet demonstrates deleting records that meet a specific criterion. It's used for data removal.

```sql
DELETE FROM Customers
WHERE CustomerName = 'Alfreds Futterkiste';
```

--------------------------------

### Claris SQL SELECT Statement Example

Source: https://help.claris.com/en/sql-reference/content/group-by-clause

Demonstrates a basic SELECT statement in Claris SQL to retrieve data from a table. This snippet is fundamental for data retrieval operations.

```Claris SQL
SELECT customerName, customerAddress FROM Customers WHERE city = "New York";
```

--------------------------------

### SQL CREATE TABLE Statement

Source: https://help.claris.com/en/sql-reference/content/where-clause

Shows the SQL CREATE TABLE statement, used to create a new table in a database. Define columns, data types, and constraints.

```sql
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
);
```

--------------------------------

### FileMaker SQL: Self-Join Example

Source: https://help.claris.com/en/sql-reference/content/from-clause

This example demonstrates a self-join in Claris FileMaker SQL, where the same table ('employee') is included twice in the FROM clause with different aliases ('E' and 'F') to compare records, such as managers and employees.

```sql
SELECT * FROM employee E, employee F WHERE E.manager_id = F.employee_id
```

--------------------------------

### DROP INDEX Example - Claris FileMaker SQL

Source: https://help.claris.com/en/sql-reference/content/drop-index-statement

This example demonstrates how to use the DROP INDEX statement to remove an index from the 'Salesperson_ID' column in the 'Salespeople' table within a Claris FileMaker database.

```sql
DROP INDEX ON Salespeople.Salesperson_ID
```

--------------------------------

### Typography for Headings and Intro (CSS)

Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects

Defines specific typographic styles for headings and introductory text within sections. This includes font size, line height, font weight, and margins for different heading levels (eyebrow, headline, intro) and sub-headings. It ensures consistent text hierarchy.

```css
.cs-fh01,.cs-sh01{width:80%;text-align:center;margin:0 auto}.cs-fh01 .cs-fh01-eyebrow{font-weight:300;font-size:24px;line-height:32px}.cs-fh01 .cs-fh01-headline{font-size:48px;line-height:52px;margin-bottom:24px}.cs-fh01 .cs-fh01-intro{font-size:20px;line-height:28px;margin-bottom:0}.cs-sh01 .cs-sh01-heading{font-size:40px;line-height:44px;margin-bottom:16px}.cs-sh01 .cs-sh01-headline{font-size:20px;line-height:28px;margin-bottom:0}
```

--------------------------------

### SQL String Function Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows an example of using a string function to manipulate text data. This snippet converts a column's content to uppercase. String functions are widely used for data cleaning and formatting.

```sql
SELECT UPPER(CustomerName) AS UpperCaseName FROM Customers;
```

--------------------------------

### Section and Feature Styling (CSS)

Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects

Styles for general page sections and feature blocks. Includes settings for width, margins, padding, background colors, and text alignment for headings and introductory text. These are foundational styles for content presentation.

```css
.cs-section-wrapper{width:100%;background-color:#fff}.cs-section-width{width:1000px;margin:0 auto}.cs-section{padding:80px 0;min-height:400px}.cs-section-bg01{background-color:#f2f2f7}.cs-feature-wrapper{padding-top:60px}.cs-feature-wrapper .cs-section{padding:120px 0}@media only screen and (max-width:1068px){.cs-section-width{width:90%}}
```

--------------------------------

### Basic SQL Query Example

Source: https://help.claris.com/en/sql-reference/content/functions-that-return-character-strings

This is a placeholder for a basic SQL query. In a real scenario, this would demonstrate a simple SELECT statement, illustrating how to retrieve data from a database. The specific tables and columns would depend on the database schema.

```sql
-- Example SQL Query
SELECT column1, column2
FROM your_table_name
WHERE condition;
```

--------------------------------

### SQL EXISTS Operator Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows how to use the EXISTS operator to test for the existence of rows in a subquery. This example selects customers for whom at least one order exists. EXISTS is often more efficient than COUNT for checking existence.

```sql
SELECT * FROM Customers
WHERE EXISTS (SELECT OrderID FROM Orders WHERE Orders.CustomerID = Customers.CustomerID);
```

--------------------------------

### Icon Styles (CSS)

Source: https://help.claris.com/en/sql-reference/content/index

Provides base styling for icons within the interface, ensuring they inherit properties and are displayed correctly. It sets up the icon font and positioning context.

```css
.cs-icon{
  font-family:"SF Pro Icons";
  color:inherit;
  display:inline-block;
  font-style:normal;
  font-weight:inherit;
  font-size:inherit;
  line-height:1;
  text-decoration:none;
  position:relative;
  z-index:1;
  alt:''
}
.cs-icon-check::after{
  text-decoration:none;
  content:"\f30b"
}
```

--------------------------------

### SQL Subquery Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates the use of a subquery (nested query) within a SQL statement. This example selects customers whose city is the same as the city of the customer with CustomerID 1. Subqueries are powerful for complex data retrieval.

```sql
SELECT * FROM Customers
WHERE City = (SELECT City FROM Customers WHERE CustomerID = 1);
```

--------------------------------

### SQL Aggregate Function SUM Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Illustrates how to use the SUM aggregate function to calculate the total sum of a numeric column. This example calculates the total sales amount. It's vital for financial and inventory reporting.

```sql
SELECT SUM(Quantity) AS TotalQuantitySold
FROM OrderDetails;
```

--------------------------------

### SQL Aggregate Function COUNT Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Demonstrates the use of the COUNT aggregate function to count the number of rows that match a specified criterion. This example counts the number of customers in Mexico. It's fundamental for data analysis.

```sql
SELECT COUNT(*) AS NumberOfCustomers
FROM Customers
WHERE Country = 'Mexico';
```

--------------------------------

### SQL CREATE TABLE Statement

Source: https://help.claris.com/en/sql-reference/content/field-names

Demonstrates the syntax for creating a new table in a database. This statement defines the structure of a table, including column names and their data types. It's essential for setting up database schemas.

```SQL
CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype
);
```

--------------------------------

### Global Navigation Responsive Styling (CSS)

Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects

CSS to apply specific styling to the English version of the global navigation for larger screens (min-width: 1069px), likely for layout adjustments.

```css
@media only screen and (min-width:1069px){.cs-globalnav-en .cs-main-nav .cs-items
```

--------------------------------

### SQL Aggregate Function AVG Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows how to use the AVG aggregate function to calculate the average value of a numeric column. This example calculates the average price of all products. Aggregate functions are key for data summarization.

```sql
SELECT AVG(Price) AS AveragePrice
FROM Products;
```

--------------------------------

### Example: Select Records with FOR UPDATE in Claris FileMaker SQL

Source: https://help.claris.com/en/sql-reference/content/for-update-clause

An example of selecting records from the 'emp' table where the 'salary' is greater than 20000, using the FOR UPDATE clause to lock 'last_name', 'first_name', and 'salary' fields for potential updates.

```sql
SELECT * FROM emp WHERE salary > 20000 FOR UPDATE OF last_name, first_name, salary
```

--------------------------------

### Example DELETE Statement - SQL

Source: https://help.claris.com/en/sql-reference/content/delete-statement

An example of the SQL DELETE statement used to remove a specific record from the 'emp' table based on the 'emp_id'. This demonstrates how to target individual records for deletion using the WHERE clause.

```sql
DELETE FROM emp WHERE emp_id = 'E10001'
```

--------------------------------

### Creating a New Table with Claris SQL

Source: https://help.claris.com/en/sql-reference/content/logical-operators

Demonstrates the SQL CREATE TABLE statement to define a new table named 'Employees'. It includes columns for 'EmployeeID', 'FirstName', 'LastName', and 'Department', with 'EmployeeID' as the primary key.

```sql
CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Department VARCHAR(50)
);
```

--------------------------------

### SQL UPDATE Statement Example

Source: https://help.claris.com/en/sql-reference/content/character-operators

Shows how to modify existing records in a database table using the UPDATE statement. This example targets specific records based on a condition and updates designated columns. It's crucial for data maintenance.

```sql
UPDATE Customers
SET Address = 'Zoutmanplein 4', City = 'Ghent'
WHERE CustomerName = 'Around the Horn';
```

--------------------------------

### CSS: Global Navigation Styles

Source: https://help.claris.com/en/sql-reference/content/filemaker-system-objects

Provides core styling for the global navigation bar, including positioning, background filters for transparent states, and layout for navigation wrappers. It defines how the navigation bar adapts to different screen states.

```css
.cs-globalnav.cs-transparent .cs-cover{
  position:absolute;
  left:0;
  top:0;
  width:100%;
  height:100%;
  -webkit-backdrop-filter:saturate(180%) blur(20px);
  backdrop-filter:saturate(180%) blur(10px);
  z-index:-1
}
.cs-globalnav .cs-fullwidth{
  height:100%
}
.cs-globalnav .cs-navwrapper{
  display:flex;
  align-items:center;
  width:1000px;
  height:100%;
  margin:0 auto
}
```

--------------------------------

### SQL Subquery Example

Source: https://help.claris.com/en/sql-reference/content/select-statement

Provides an example of a subquery (also known as a nested query or inner query), which is a query embedded within another SQL query. Subqueries can be used in SELECT, FROM, WHERE, and HAVING clauses to perform complex data operations.

```sql
SELECT column_name
FROM table_name
WHERE column_name IN (SELECT column_name FROM another_table WHERE condition);
```

--------------------------------

### Claris SQL: Drop Default Value Example

Source: https://help.claris.com/en/sql-reference/content/alter-table-statement

Example demonstrating the removal of a previously set default value for a column in Claris SQL via the ALTER TABLE statement. This reverts the column to not having a default value.

```sql
ALTER TABLE Salespeople ALTER Company DROP DEFAULT
```

--------------------------------

### Claris SQL: Remove Column Example

Source: https://help.claris.com/en/sql-reference/content/alter-table-statement

Example of using the ALTER TABLE statement to remove an existing column from a table in Claris SQL. This operation permanently deletes the specified column and its data from the table structure.

```sql
ALTER TABLE Salespeople DROP C1
```

--------------------------------

### Claris SQL DELETE Statement Example

Source: https://help.claris.com/en/sql-reference/content/truncate-table-statement

Provides an example of how to remove records from a Claris database table using an SQL DELETE statement. This operation should be used with caution as it permanently removes data. It requires specifying the table and the conditions for deletion.

```sql
DELETE FROM Customers
WHERE CustomerID = 12
```
Tokens:
Raw