Skip to Content
-1
Jan 20, 2020 at 12:37 PM

Wild card entry for ? (Question mark) in the NVARCHAR column in HANA expression in calculation view

238 Views Last edit Jan 20, 2020 at 12:38 PM 2 rev

Dear Team,

In a SLT table AUSP, we have a column OBJEK and business needs to fetch the OBJEK which starts with ? (Symbol).

I tried with below cases in expression editor of Projection in a view and it did not work.

Option 1: match("OBJEK",'?*')

Option 2: match("OBJEK",'\?*')

Option 3: match("OBJEK",'\[?]*')

Option 4: match("OBJEK",'[\?]*')

Please suggest if I am doing any wrong on the above.

Sample data in a table AUSP for this field OBJEK are:

?0100000000000089665

?

000000000000096653