Functions/Text & patterns/starts_with
Text & patterns Scalar

starts_with()

Returns true if string begins with search_string.

Alias of ^@

Arguments & returns

starts_with(string, search_string)

Scalar
Overload link stringsearch_string Returns
#01 VARCHARVARCHAR BOOLEAN

Example

starts_with example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Used in larger rewrites 1

These examples use starts_with as one part of a larger SQL translation.

Snowflakeprevious_day()

SELECT PREVIOUS_DAY(DATE '2024-01-15', day_column)
In DuckDB
SELECT CAST(CAST('2024-01-15' AS DATE) - INTERVAL ((((ISODOW(CAST('2024-01-15' AS DATE)) - CASE WHEN STARTS_WITH(UPPER(day_column), 'MO') THEN 1 WHEN STARTS_WITH(UPPER(day_column), 'TU') THEN 2 WHEN STARTS_WITH(UPPER(day_column), 'WE') THEN 3 WHEN STARTS_WITH(UPPER(day_column), 'TH') THEN 4 WHEN STARTS_WITH(UPPER(day_column), 'FR') THEN 5 WHEN STARTS_WITH(UPPER(day_column), 'SA') THEN 6 WHEN STARTS_WITH(UPPER(day_column), 'SU') THEN 7 END) + 6) % 7) + 1) DAY AS DATE)

SQLGlot example ↗