[Feature Request] Case insensitive JOIN candidates

shadowbob

As the subject suggests, can we get an option to list JOIN candidates using case-insensitive comparison? I need the names to match (not just the data types), but sometimes the case differs a bit from table to table. Thanks!

shadowbob

I apologize, I just realized the JOIN I was trying to do actually contained an underscore (_) in the field on one table, but did not contain it on the other table. This, in addition to a case difference. Perhaps SQL Prompt already ignores case? Maybe someone can confirm this. (You know it'd be super cool if the underscore could be removed during the comparison...)