I know of many adult Andrews, but most do go by
Andy. However, I am in highschool and 2 of the 4 Andrews in my grade go simply by
Andrew. (the other two are both Andys). You may have a bit of a problem with the nickname thing, but I don't think you will as much as with
Abigail.