Is The Sql Delete Statement Case Sensitive?

I need to delete a record from a SQL server database table. I need to target a specific column with a query that looks like the following:

delete from NameTable where Name = 'Barbosa'

The problem is that their are two other records with the name spelled similarly, only differing by case sensitivity. Like as follows:

'Barbosa'

'barbosa'

'BarBosa'

Is sql case sensitive? Will my Sql delete statement only delete the record with the word 'Barbosa' in that column. Or will it delete all of the records with the names

'Barbosa'

'barbosa'

'BarBosa'