---
schema_version: "1"
id: 59f4f1f17c22dc65e78687eb67ee1fdf258d3f34dd84b87aa88191e61158f8c7
title: Scalar Functions and Operators
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/scalar-functions.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/scalar-functions.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 1f36147adf1d8f11abaabba6084b922c0e739984eb4d89a54b7de77b5c3ee29b
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# Scalar Functions and Operators

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Functions and operators compute one result for each set of input values. Use scalar functions and operators to transform values, compare data, perform calculations, and control how expressions are evaluated.

## AI Functions

Use generative AI models to classify text, analyze sentiment, and generate text.

- [AI Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/ai-func/ai-funcs.md) - Classify text, determine sentiment, or generate text from a prompt.

## Collection and Structured Data Functions

Create, inspect, and transform arrays and JSON values.

- [Array Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-func/arrays.md) - Access, search, build, transform, and compare arrays and vectors.
- [JSON Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/json-func/json-funcs.md) - Construct JSON values from SQL values, arrays, and key-value pairs.

## String Functions

Format, transform, search, and compare text values.

- [String Functions and Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string-func/string-func.md) - Concatenate, measure, extract, trim, encode, hash, and transform strings.
- [String Pattern Matching](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string-matching/string-matching.md) - Match strings with `LIKE`, regular expressions, and related functions.

## Formatting and Type Conversion

Convert values between data types or format values for display.

- [Data Type Formatting Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/formatting-func/formatting-func.md) - Convert numbers, dates, timestamps, and other values to or from formatted strings.
- [Type Conversions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/type-conversion.md) - Convert an expression from one data type to another.

## Comparison and Logical Operations

Compare values and combine or negate conditions.

- [Comparison Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/comparison.md) - Compare values for equality, ordering, ranges, nullness, and distinctness.
- [Subquery Comparisons](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/subquery-comparison.md) - Compare scalar values with rows returned by a subquery.
- [Logical Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/logical.md) - Combine or negate Boolean expressions with `AND`, `OR`, and `NOT`.

## Conditional Expressions

Choose a result based on conditions or available values.

- [Conditional Expressions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/conditional.md) - Select among values with `CASE`, `COALESCE`, `NULLIF`, `GREATEST`, and `LEAST`.

## Mathematical Functions

Perform numeric calculations.

- [Mathematical Functions and Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/math.md) - Perform arithmetic, rounding, logarithmic, trigonometric, bitwise, and other numeric operations.

## Date and Time Functions

Create, inspect, compare, and modify temporal values.

- [Date/Time Functions and Operators](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/datetime-func.md) - Calculate with dates, times, timestamps, and intervals; extract fields; and truncate temporal values.