I knew about this method but I wanted a way to do the whole table in one go.

This UPDATE method requires me to go through every single column (56 of...

What I mean is that if I view the entire table som of the fields say <NULL> whilst others are just empty (nothing in them at all).

It's the ones with...

Thanks for the input guys.  I am going to try the stored procedure that Tyson posted.  That looks as if it may answer my question,  I didn't want loads of...

I think I have to use full text search which I don't really want to turn on incase I get a performance hit.  I just cant rememebr if that is...