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!
Comments
1 comment
-
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...)
Add comment
Please sign in to leave a comment.