I think @Martin Smith's reply: is really good. I just flipped his answer from a double negative [not lowercase] to a positive [is uppercase]:

SELECT *
FROM Cust
WHERE Surname LIKE '%[A-Z]%' COLLATE Latin1_General_BIN