In canada : if it is a shortcode (very short phone number) STOP is probably supported at the carrier level.

Any regular phone number, you are probably just telling the spammer you are a real person with a working number and you will receive 10x more spam