Consider the following entries in my table:
red apple
yellow apple
apple green
red aple
appel yellow
Several people have populated this table using a non-consistend notation (the color before or after 'apple'), also entering some spelling errors.
Now I …
how do I cast a blob to varchar with SAP HANA database using SQL.
(we need the column to be stored in blob - not TEXT - in else HANA automatically creates an index on this column. But we need …
I have a table with a string column. I convert this column to a number using the function TO_INTEGER(). Ist work fine. But If I Aggregate the converted column with the function SUM I got this error:
SAP DBTech …