User Tools

Site Tools

A PCRE internal error occured. This might be caused by a faulty plugin

Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

replace

====== REPLACE Function - HPL/SQL Reference====== REPLACE function replaces all occurrences of the specified substring with another substring. **Syntax**: <code language="sql"> REPLACE(string, what, with) </code> **Parameters:** | **Parameter** | **Type** | **Value** | **Description** | | //string// | String | Variable or expression | Original string | | //what// | String | Variable or expression | Which substring to replace | | //with// | String | Variable or expression | Replacement | **Return Type:** String. **Example:** <code language="sql"> replace('2016-03-03', '-', ''); -- 20160303 </code> **Compatibility**: Oracle, Microsoft SQL Server, IBM DB2 and MySQL. **Version**: HPL/SQL 0.3.17