replace({str}, {old_str}, {new_str})

Replaces all occurrences in string str of a substring old_str with a new substring new_str. Returns a new string.

This example replaces instances of ‘Al’ with ‘AL’ in the City column. The query returns the first five entries.