About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

REPLACE

Replaces characters in a string with a specified substring. REPLACE searches the input string for all instances of the substring you specify and replaces them with the replacement string you specify.

Syntax

REPLACE ( InputString, Substring[, ReplacementString] )

Argument	DataType	Description
InputString	char	String in which to search for a substring to be replaced by another string.
Substring	char	Substring to search for that you want to replace with ReplacementString.
ReplacementString	char	Optional. String to replace Substring. If you do not pass this parameter, REPLACE deletes all occurrences of Substring.

Return Value

String with the specified substring replaced or deleted.

Example

If a column named col1 contains the string "The fox sees another fox in the meadow.", the following expression replaces all instances of the substring "fox" with the string "rabbit":

REPLACE ( col1, 'fox', 'rabbit' )

The function call returns the following string:

The rabbit sees another rabbit in the meadow.

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

REPLACE

REPLACE

Syntax

Return Value

Example