Hi, I think I found out what was wrong.
ColfFusion has a tag <CFQUERYPARAM> that prevents SQL Injection. Probably <CFQUERYPARAM> was removing anything after comma. Without using <CFQUERYPARAM> the code works perfectly. So, I had to create a UDF to remove everything except digits and commas. Thanks in advance, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]