In food prep areas they make you remove it, if you can't then you either put a small bandage to cover it up or don't work on food prep.
If you work nightcrew and the store is closed to customers, then I don't think they say too much. If you are in the checkstand it depends on management (and if they like you). But just to be safe, I would ask store management about the policy concerning nose rings