cancel
Showing results for 
Search instead for 
Did you mean: 

CHARINDEX FUNCTIONALITY IN HANA

eonsase
Participant
0 Kudos
2,135

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;

Accepted Solutions (0)

Answers (1)

Answers (1)

CharlesFeng
Advisor
Advisor
0 Kudos

Hi ernestonsase,

Have you tried to solution provided by michael.eaton3?
----------------------------------------
You can use the LOCATE function
- https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20e3b6b77519101485e6bd6...

----------------------------------------


In HANA, there is no function CHARINDEX. You can find more details about what functions are supported in HANA via below help guide:
https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20a61f29751910149f99f03...

Best regards,
Charles