is it possible to automate sql search?

hello, is it possible to automate or use sqlcmd with sql search? I need to search 500 databases for instances of *= or =* (old join types) before I can upgrade the db's these need to be fixed and I was hoping to have a way to automate or use sqlcmd to run the search thru each db and output the dbname and function/view/stored procedure that has the old join type.

thanks!!!