Hey all,

Nothing to do with business, more diagnostics. Just wanted something quick and dirty - I guess a lazy way of checking.

Suppose a situation where you have a record in one table column, with a value of fred. Now you know that data is lurking somewhere in another table (that will have fred as a value somewhere). Like a third party database someone else has written 🙁

Now suppose you identify the table but there are lots of columns to find 'fred' in.

Instead of typing WHERE Column1 = 'fred' OR Column2 = 'fred' and so on...

I'd thought about dynamic script first but then I've had the odd bit of SQL that was "new to me" of late so wondered if there was some part of the SQL syntax I may have overlooked.

Andez