SELECT "DISTINCT"

J

JimP

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

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.
 
Top