Case Sensitivity

If Case Sensitivity is required in search "where" condition, query is below

Note : As you could see, country = 'India' is fetched, but country = 'INdia' is not fetched. Thus case sensitivity is achieved with the help of CAST and varbinary. The 5 within brackets is the length of the word which is searched.[In our case,"India(INdia)" is the word which is searched].