[11:29:08 CDT(-0500)] <dmccallum54> TonyUnicon re SQLServer case (in)sensitivity
[11:29:20 CDT(-0500)] <dmccallum54> – B2D05919-5056-A51A-80BD-03E5288DE771, CAP
[11:29:20 CDT(-0500)] <dmccallum54> select top 1 id, name from student_type
[11:29:20 CDT(-0500)] <dmccallum54> – B2D05919-5056-A51A-80BD-03E5288DE771
[11:29:20 CDT(-0500)] <dmccallum54> select id from student_type where name = 'cap'
[11:29:20 CDT(-0500)] <dmccallum54> – B2D05919-5056-A51A-80BD-03E5288DE771
[11:29:21 CDT(-0500)] <dmccallum54> select id from student_type where name = 'CAP'
[11:29:37 CDT(-0500)] <dmccallum54> that's from our Wins CI db
[11:30:27 CDT(-0500)] <dmccallum54> if that's true, then the only reason we'd need derived columns in SQLServer would be if the application or the views will generate lower() queries and that would cause SQLServer to skip indexes
[11:33:20 CDT(-0500)] <dmccallum54> jumping on the phone for another call...
[11:33:25 CDT(-0500)] <TonyUnicon> yep