I know I’m doing this wrong, I just can’t wrap my head around how to do this the right way.

The data looks like this:

  IF
  (
      Contact_Name like '%E%',cast(Contact_Name AS NUMERIC),
      (
          IF
              (
                  Contact_Name like '+1%',LTRIM(Contact_Name,'+1'),
                  (
                      IF
                          (
                              Contact_Name like '+%',LTRIM(Contact_Name,'+'),Contact_Name
                          )
                  )
              )
      )
  ) as CN

I’m looking for the result to look like this: