summaryrefslogtreecommitdiffstats
path: root/yql/essentials/udfs/common/string/test/cases/Find.sql
blob: 273553dcf9e1aa71dd4fbec96684e72583ec1b1d (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
/* syntax version 1 */
SELECT
    value,
    String::Contains(value, "as") AS contains,
    String::HasPrefix(value, "as") AS prefix,
    String::StartsWith(value, "as") AS starts,
    String::HasSuffix(value, "as") AS suffix,
    String::EndsWith(value, "as") AS ends,
    String::Find(value, "as") AS find,
    String::ReverseFind(value, "as") AS rfind,
    String::LevensteinDistance(value, "as") AS levenstein
FROM Input;