1. SET QUOTED_IDENTIFIER OFF
----- Select * From xTable Where xCols = N"Cann't"
----- Word by Word N"Cann't"
--------- N-Double Quot-C-a-n-n-Singgle Quot-t-Double Quot
Solution 2.
2. Use Command Parameter
----- Select * From xTable Where xCols = @BAN
----- Command.Parameter.AddWithValues("@BAN", "Cann't")
----- Word by Word "Cann't"
--------- N-Double Quot-C-a-n-n-Singgle Quot-t-Double Quot