After spending more time looking at this issue in depth, having Chris unsure of a resolution and not getting any other feedback from this post or the equivalent one on Stack Overflow - http://stackoverflow.com/questions/4302779/can-red-gate-sql-source-control-identify-a-case-change
- I'm calling this one a bug. I'd love to be proven wrong, but that seems to be the case (sorry about the pun!).
So to specifically answer my question, no, it appears SQL Source Control can't natively version a case-only change. However, there is a workaround involving making the change in the working directory and submitting this back via TortoiseSVN (assuming the VCS is SVN). Th full details are now in "Defeating Red Gate’s SQL Source Control insensitivity" - http://www.troyhunt.com/2010/12/defeating-red-gates-sql-source-control.html