SQL, Find if a column in any of my tables has some info

I'm kind of new using SQL, but I keep learning. Right now I have the challenge to compare some information from diferent sources. But I have the idea that we have the data into some tables. The real problem is I have no idea which table could have the info.

The data I'm searching is like this always : HA00XXXX

Where X is a number.

Any of you guys, know a way to look into all the tables if there is a column with this format? As far as I know there is the command "like" that I could use when I know which table.

Thanks in advance

Best Regards