---
title: Functions Overview
description: Function names are used to apply a function to values, to values at
  a specified path, or to values derived from a DISTINCT clause.
pubDate: 2026-08-17T09:53:44.266Z
antora:
  editUrl: https://github.com/couchbaselabs/docs-devex/edit/capella/modules/n1ql/pages/n1ql-language-reference/functions.adoc
  xref: xref:cloud:n1ql:n1ql-language-reference/functions.adoc[]
---

[Consult the llms.txt file for a full list of contents](/llms.txt)
[View original HTML](/cloud/n1ql/n1ql-language-reference/functions.html)

# Functions Overview

> Function names are used to apply a function to values, to values at a specified path, or to values derived from a DISTINCT clause. Function names are case insensitive. 

Here are the categories of SQL++ functions:

* [Aggregate Functions](aggregatefun.md)
* [Array Functions](arrayfun.md)
* [Bitwise Functions](bitwisefun.md)
* [Comparison Functions](comparisonfun.md)
* [Conditional Functions for Unknowns](condfununknown.md)
* [Conditional Functions for Numbers](condfunnum.md)
* [Date Functions](datefun.md)
* [JSON Functions](jsonfun.md)
* [Miscellaneous Utility Functions](metafun.md)
* [Number Functions](numericfun.md)
* [Object Functions](objectfun.md)
* [Pattern-Matching Functions](patternmatchingfun.md)
* [Search Functions](searchfun.md)
* [String Functions](stringfun.md)
* [Token Functions](tokenfun.md)
* [Type Functions](typefun.md)
* [User-Defined Functions](userfun.md)
* [Vector Functions](vectorfun.md)
* [Window Functions](windowfun.md)