|
2021년 1월부터 기존 파일 형식을 더 이상 사용할 수 없습니다. 기존 파일을 전환하거나 PDF를 다운로드할 수 있습니다. 자세히 알아보기

Working with SQL Editor for building query

답변함
데모 요청하기

I am trying to write a query involving string functions of SQL such as 'CHARINDEX' or 'PATINDEX' to check the existence of a particular pattern within a cell data. On executing the query, I get an error saying CHARINDEX function not registered. Do we have to use any other syntax or how do we register these functions?

0

댓글

댓글 2개

날짜 투표수
  • 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

댓글을 남기려면 로그인하세요.