Skip to content
ScopeDB
DOCUMENTATION
Book a demo
Search
Guides
Developer
Reference
Overview
Data types
Overview
Date and time
Variant
Conversion
Commands
Overview
Query Syntax
Query Operators
Overview
Arithmetic
Comparison
Logical
Set operators
General DDL
General DML
Functions
Overview
Aggregate
Overview
approx_quantile
avg
count
max
max_by
min
min_by
mode
stddev_pop
stddev_samp
sum
variance_pop
variance_samp
Conditional expression
Overview
IS [ NOT ] DISTINCT FROM
IS [ NOT ] NULL
Conversion
Date and time
Overview
now
trunc
Numeric
Overview
ceil
floor
round
trunc
String
Overview
concat, ||
contains
ends_with
length
ltrim
lower
regexp_like
replace
reverse
rtrim
search
split
starts_with
substr
trim
upper
Variant data
Overview
array_append
array_concat, ||
array_construct
array_contains
array_except
array_length
array_slice
get, []
object_construct
object_keys
parse_json
to_json
typeof
GitHub
lower
Returns the input string with all characters converted to lowercase.
Syntax
Section titled “Syntax”
lower
(
<
expr
>
)
ScopeDB
© 2025 ScopeDB. All rights reserved.
Get Started
Book a demo
Visit ScopeDB
Product
Documentation
Changelog
Pricing
Company
About
Blog
Terms of Service
Privacy Policy
Connect
Contact us
GitHub
Discord