- Description: Replaces occurrences of a substring within a string.
- Purpose: Useful for data correction and formatting.
- Syntax:
REPLACE(string, search_string, replace_string) - Parameters:
string: Original string.search_string: Substring to replace.replace_string: Replacement substring.
- Returns: The modified string.
- Example:
REPLACE('Hello World', 'World', 'Oracle')returns'Hello Oracle'. - Notes: Replaces all occurrences.
- Use Case: Correcting typos in user inputs.
Leave a Reply