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