FIND in Tableau: the SQL equivalent, with a worked example

FIND([label], 'e')

label	quantity	amount	flag
cedar cedar	65	12.8	True
ORCHID-west	66	-7.6	False
maple-east	67	0	null
willow north	68	25.3	True
birch-birch	69	4.9	False
pine/south	70	-1.2	null
ash	71	9	True
null	null	null	null

SELECT strpos(label,'e') AS result FROM input

Runs the example above.

SELECT POSITION('e',label) AS result FROM input

Written for this dialect; not run here.

SELECT STRPOS(label,'e') AS result FROM input

Written for this dialect; not run here.

Same rows from the calculation and from the SQL in DuckDB.

Where a naive translation goes wrong

Replacing FIND with nullif(strpos(label,'e'),0) changes the shown values or null handling.
Naive SQL
```
SELECT nullif(strpos(label,'e'),0) AS result FROM input
```
result
4
9
5
null
null
4
null
null
Matches the calculation
```
SELECT strpos(label,'e') AS result FROM input
```
result
4
9
5
0
0
4
0
null

FIND(string, string, [start])