You can use a function created in a standard module in any query in the database.

Standard Module

In software development, a reusable collection of code housed in a single unit or file, often containing procedures and functions that can be accessed by various parts of a program.

Function Procedure

A procedure in programming that performs a specific task and returns a value to the caller.