> 2.) The Like function in SQL Server is case insensitive, PG it is case > sensitive. The ilike function is not recognised by Access and it tries > to turn that into a string, making my test (like "ilike 'blah'") > > Has anyone had any experience with moving an access program from SQL > server to PG? > > Is there any way to change the text qualifier in PG or the case sensitivity? I wonder if this would be a good feature to request from the ODBC developers by adding a parameter to the drivers to use ilike instead of like. Regards, Richard Broersma Jr.
