01.DELIMITER @@
02.CREATE FUNCTION RepSpialChar(Instr Text)
03.RETURNS Text
04.BEGIN
05. DECLARE Outstr Text;
06. SET Outstr=REPLACE(Instr,'!',' ');
07. SET Outstr=REPLACE(Instr,'#',' ');
08. SET Outstr=REPLACE(Instr,'$',' ');
09. SET Outstr=REPLACE(Instr,'%',' ');
10. SET Outstr=REPLACE(Instr,'&',' ');
11. SET Outstr=REPLACE(Instr,'(',' ');
12. SET Outstr=REPLACE(Instr,')',' ');
13. SET Outstr=REPLACE(Instr,'*',' ');
14. SET Outstr=REPLACE(Instr,'+',' ');
15. SET Outstr=REPLACE(Instr,',',' ');
16. SET Outstr=REPLACE(Instr,'.',' ');
17. SET Outstr=REPLACE(Instr,'/',' ');
18. SET Outstr=REPLACE(Instr,':',' ');
19. SET Outstr=REPLACE(Instr,';',' ');
20. SET Outstr=REPLACE(Instr,'<',' ');
21. SET Outstr=REPLACE(Instr,'=',' ');
22. SET Outstr=REPLACE(Instr,'>',' ');
23. SET Outstr=REPLACE(Instr,'?',' ');
24. SET Outstr=REPLACE(Instr,'@',' ');
25. SET Outstr=REPLACE(Instr,'[',' ');
26. SET Outstr=REPLACE(Instr,']',' ');
27. SET Outstr=REPLACE(Instr,'^',' ');
28. SET Outstr=REPLACE(Instr,'_',' ');
29. SET Outstr=REPLACE(Instr,'`',' ');
30. SET Outstr=REPLACE(Instr,'{',' ');
31. SET Outstr=REPLACE(Instr,'|',' ');
32. SET Outstr=REPLACE(Instr,'}',' ');
33. SET Outstr=REPLACE(Instr,'~',' ');
34. SET Outstr=REPLACE(Instr,'‘',' ');
35. SET Outstr=REPLACE(Instr,'ฯ',' ');
36. SET Outstr=REPLACE(Instr,'',' ');
37. SET Outstr=REPLACE(Instr,'฿',' ');
38.RETURN Outstr;
39.END@@
40.DELIMITER ;
Load balance : Server 03
