Skip to Content
0
Oct 13, 2022 at 08:26 AM

CHARINDEX FUNCTIONALITY IN HANA

1176 Views

I am running the below query on HANA but it is giving me an error of "Invalid name of function or procedures: CHARINDEX". When I try to run it on SQL it does not give an error. How can I format it to be HANA compliant for the function.

SELECT * FROM OUSR

T0

WHERE CHARINDEX( 'K', T0.U_NAME ) = 1;