Determine a Value from a customized field in a select statement.

I am new.  I am looking to determine the value of a customized field based on the value of a previous customized field.  Here is what I have so far: select c.*, CASE  WHEN c.[Case End Date] is nul...