What are the challenges you face when working across database platforms? Take the survey
Options

[Feature Request] Case insensitive JOIN candidates

shadowbobshadowbob Posts: 71 Bronze 2
edited December 1, 2008 9:05PM in SQL Prompt Previous Versions
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!
Jeremy Fuller
VP, Software Development
Organizational Intelligence, Inc.

Comments

  • Options
    shadowbobshadowbob Posts: 71 Bronze 2
    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...)
    Jeremy Fuller
    VP, Software Development
    Organizational Intelligence, Inc.
Sign In or Register to comment.