Names question

Megan

My husband and I just found out we are having a little baby boy!! My husband’s name is Andrew and literally everyone we know calls him Drew and has since childhood. I love the idea of naming our son Andrew (with a different middle name) and having him go by Andy but my husband isn’t sold on the idea. Our son wouldn’t be a Jr and would definitely have his own identity with the different nicknames.

I’m just hoping for more opinions. Let me know what you ladies think!