The REMOVE function searches a given source string,
removes all instances of a provided search string, and returns the
result. As optional behaviors, parameters can be provided to
specify whether or not the search is case-sensitive, and to specify
the starting position within the source string to begin the search.
Parameters
@REMOVE
(Source String, Search String [, Case Sensitive [, Start Position]])- Source String Required string parameter; contains the source string to be
searched by the function.
- Search String Required string parameter; contains the sub-string to be removed
from Source String.
- Case Sensitive Optional Boolean parameter; when provided, indicates whether
or not the search of Source String for Search
String should be case-sensitive. If this value is true
or not specified, the search is case-sensitive. If set to false,
case is ignored.
- Start Position Optional integral number parameter; when provided, specifies
the zero-based position within SourceString to
begin the search. The default is to begin at position 0.