Find Field Value

[doco]

I know I can use

SELECT
	so.name as table_name
FROM
	sysobjects so inner join syscolumns sc
	on so.id = sc.id
WHERE
	sc.name like 'p%cla%'

To find all tables in a database with a certain field name or name pattern. What I would like to do is write a script that will search all tables for a given field value returning the table name with that field value.

Make Sense?
TIA

 

[SQL_Hell]

Hello!

Found something here:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Bookmarking it for myself too, might some in handy

 

[doco]

Thanks a bunch looks like it will do the trick