How much pressure in a 100 mm diameter vertical pipe with 40 meters height?

It depends on whether the pipe is open or closed and what it contains. If the pipe is full of water to a height of 40 m and open at the top, the pressure at the bottom is about 57 psig. The diameter doesn't matter.