The case-sensitivity is not related to operators in SQL Server. It depends on whether you have case-sensitive collation defined for your database/table. You can force case-sensitivity in your like statement...

No You can't..although you call call a stored procedure inside other Stored Proc.