SQL Server Case Sensitivity

J

JimP

I'm working with (2) SQL Server db's, both with case sensitivity enabled .

In one case, I have a query that links a local table, with lower case codes,
to a SQL Server table with upper case codes - All matching records are
retrieved (case sensitivity apparantly is NOT enforced)

In the other case, the query does not retrieve any records (case sensitivity
apparantly is enforced).

I would like to NOT enforce case sensitivity, and am at a loss to figure out
why it is not enforced in the first case and is in the second.
 
R

Robert Morley

I'm no expert, so I can't really help beyond this suggestion, but I believe
you can enforce rules like this at the field level in SQL Server. Perhaps
you should poke around the various field properties and see if something is
defined.


Rob
 
Top