firebird replace문
REPLACE() Syntax: REPLACE (str, find, repl) Examples: replace ('Billy Wilder', 'il', 'oog') -- returns 'Boogly Woogder'replace ('Billy Wilder', 'il', '') -- returns 'Bly Wder'replace ('Billy Wilder', null, 'oog') -- returns NULLreplace ('Billy Wilder', 'il', null) -- returns NULLreplace ('Billy Wilder', 'xyz', null) -- returns NULL (!)replace ('Billy Wilder', 'xyz', 'abc') -- returns 'Billy Wild..