I wanted to do select multiple values and tried the following but it seems like it just selects "Active" ones.
I need to select "Active" & "Existing",
fc2 = "sde\\blah\\UpdatePoints"
arcpy.DeleteFeatures_management(fc2)
#Output = "UpdatePoints1"
CCAP = "sde\\points\\Points1"
where_clause = "Status IN ('Active%','Existing%')"
arcpy.MakeFeatureLayer_management(CCAP, "CCAP1_lyr", where_clause)
arcpy.Append_management("CCAP1_lyr", "sde\\blah\\UpdatePoints", "NO_TEST")