how to deal with upper case, lower case and sentence case in the data


i want to create a calculated column like : case when [City Type] = "New York" then [City Type] else NULL END.

but what if my data changes and the data coming into City type column changes to uppercase like "NEW YORK". how to deal with caluclations like this? do we have something similar to "like function" as in SQL?

throw some light on this issue.

Thanks in advance.

(1) Answer