0
drop function if exists RemoveSpaces;
create function RemoveSpaces (txt varchar(8000))
returns varchar(8000)
begin
  declare pos integer;
  while true do
    set pos = position(', ' in txt);
    if pos=0 then
      leave;
    end if;
    set txt = substring(txt from 1 for pos)||substring(txt from pos+2);
  end while;
  return txt;
end;
Category: 
SQL Functions & Procedures
Current Version: 
1.00
Supported Products: 
NexusDB V2
NexusDB V3
Home