J JimP Feb 21, 2008 #1 I thought this was case insensitive, but a query is showing duplicate values based on case. Is there a way to make it case insensitive?
I thought this was case insensitive, but a query is showing duplicate values based on case. Is there a way to make it case insensitive?
J JimP Feb 21, 2008 #2 Yes, it is a SQL Server db with fields set to case sensitive. I converted queried fields to Lcase or Ucase and that seems to solve the problem.
Yes, it is a SQL Server db with fields set to case sensitive. I converted queried fields to Lcase or Ucase and that seems to solve the problem.
