Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

HANA Instr function to check for numbers?


I am trying to create a calculated column to check the validity of another field for the presence of numbers in the string.

For example

Partner     Tel_number     Valid

1               1flowers          Yes

2               Telephone       No 

3               6046060543    Yes

My Expected result would be for partner 1 and 2 to return valid results and partner 2 to be invalid.

What is the correct syntax for instr to do this?

I've already tried the following:


IF(INSTR("TEL_NUMBER",'1' OR '2' ...... ),0,1)



Former Member
Not what you were looking for? View more on this topic or Ask a question