Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Working with SQL Editor for building query

Answered
0

Comments

2 comments

  • Steve Stegelin

    Hi! The SQL Editor uses Presto syntax, which supports specific string functions (and it doesn't look like CHARINDEX is one of them).

    For your need, you may want to try

    position(substring IN string) → bigint

    which returns the position of the first instance of a substring within a string. 

    0
  • A Aishwarya Dharani

    Thank you so much! Will check on that.

    0

Please sign in to leave a comment.