> SQL> SELECT EMAIL,NAME,_MAXWELLPLACE FROM LISTSERV WHERE {fn > SQL> UCASE(EMAIL)} LIKE ? {escape '*'} > >>> 37000/1064: [MySQL][ODBC 3.51 Driver][mysqld-4.1.7-nt]You have an > >>> error in your SQL syntax; check the manual that corresponds to your > >>> MySQL server version for the right syntax to use near '{escape > '*'}' The syntax is correct, but it seems that the ODBC driver you are using does not recognize it. Some LISTSERV functions will not work then. There may be a newer ODBC driver that solves this problem. Eric