https://communities.sas.com/t5/SAS-Procedures/Case-Sensitivity-with-quot-Like-quot-in-Proc-SQL/m-p/17987#M3487 I ran into a situation where I wasn't getting the expected reults in a Proc SQL query. The line on my select statement was: "sum(case when table.name LIKE '%stove%' then 1 else 0 end) as TotalCount. I wasn't getting the correct results and discovered that the LIKE function is case-sensitive, causing the problem. However, I also discovered if I change the above line to "count(*) as TotalCount" and then use the like statement in the left join line: "LEFT JOIN table on table.id = root.id and table.name LIKE '%stove%' ", it isn't case-sensitive.<BR /> <BR /> 1st question, is there a way to make the LIKE function case-insenstive all the time? 2nd question, does anyone know why it would be case-sensitive in certain situations and not in others? Fri, 07 May 2010 19:22:15 GMT jlcalbre 2010-05-07T19:22:15Z https://communities.sas.com/t5/SAS-Procedures/Case-Sensitivity-with-quot-Like-quot-in-Proc-SQL/m-p/17987#M3487 I ran into a situation where I wasn't getting the expected reults in a Proc SQL query. The line on my select statement was: "sum(case when table.name LIKE '%stove%' then 1 else 0 end) as TotalCount. I wasn't getting the correct results and discovered that the LIKE function is case-sensitive, causing the problem. However, I also discovered if I change the above line to "count(*) as TotalCount" and then use the like statement in the left join line: "LEFT JOIN table on table.id = root.id and table.name LIKE '%stove%' ", it isn't case-sensitive.<BR /> <BR /> 1st question, is there a way to make the LIKE function case-insenstive all the time? 2nd question, does anyone know why it would be case-sensitive in certain situations and not in others? Fri, 07 May 2010 19:22:15 GMT https://communities.sas.com/t5/SAS-Procedures/Case-Sensitivity-with-quot-Like-quot-in-Proc-SQL/m-p/17987#M3487 jlcalbre 2010-05-07T19:22:15Z https://communities.sas.com/t5/SAS-Procedures/Case-Sensitivity-with-quot-Like-quot-in-Proc-SQL/m-p/17988#M3488 Hi,<BR /> <BR /> Using the following statement will probably fit with your needs:<BR /> <BR /> sum(case when upcase(table.name) LIKE '%STOVE%' then 1 else 0 end) as TotalCount<BR /> <BR /> Regards,<BR /> Florent Mon, 10 May 2010 13:00:50 GMT https://communities.sas.com/t5/SAS-Procedures/Case-Sensitivity-with-quot-Like-quot-in-Proc-SQL/m-p/17988#M3488 Florent 2010-05-10T13:00:50Z