# Combining LIKE and CONTAINS operator in SAP HANA

SAPSAP HANA

The code you are using \1+ just removes consecutive occurrences only. You can use the below code.

SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL)  FROM DUMMY

The output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.

Published on 09-Feb-2018 15:56:29