I WAS DRUNK OR INTOXICATED: The Wildest Legal Defense Ever?

Can a person claim a full defence when he or she commits a crime in an intoxicated or drunk state? what does the law say?