> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings