Hi. I am migrating part of a big database of MSSQL to MySQL . The tables are migrated and data is ok but I need the views that I used on MSSQL . I tried this , I replaced the name of the view used with the sql statement , a very big select statement. I have checked SQL syntax with MySQL documentation and I think it's ok. It gives me with mysql_errorno the error 1064, any ideas? . Is there any program , script , etc to migrate to MySQL SQL syntax the views of MSSQL . Later, Jorge Gimenez