The str_replace function now accepts NULL in the third parameter and treats it as an attempt to replace string_expression2 with NULL, effectively turning str_replace into a “string cut” operation.
For example, the following returns “abcghijklm”:
str_replace("abcdefghijklm", "def", NULL)
Copyright © 2005. Sybase Inc. All rights reserved. |