No there is diffrent columns in all the tables, I'm just looking a specific value in one of the tables im not sure which table the column is in though.

Yes that is correct I wish to search out a given value in all the columns in a database.