Solved: how to check to see if a value is numeric in sap h...

Former Member · ‎11-05-2013

Hi,

Is there a SQL function or Calculation functions in HANA that
checks for a data type?

I need to check a column value to see if it contains numbers or characters,
but I don't see any functions that will do that.

Is there an IS_NUMERIC equivalent function is HANA?

Thank You,

Hyun Grasso

jan_nyfeler2 · ‎11-23-2023

Why not use LOCATE_REGEXPR?

LOCATE_REGEXPR('^(0|[1-9][0-9]*)$' in <Your_Col_Name>)

how to check to see if a value is numeric in sap hana