That's the way to do it, but without knowing the data, we can't help you. You'll have to set the values so that they mean something.

can you send the columns definition so we can try to figure it out?

I feel I must restate this :

trim (char(' ')) = ' '

Or use nulls if you don't know what to put there.

Thanx... borgs are not satisfied with anything less than perfection .

I don't know why I'd do that... almost all the data would have to be manually recheck for validity... why not go down that road instead??

"rgR'us has a 'pretty' good track record"

Hey I'm only half borg... so I'm gonna do a mistake once in a while .

Nice quote...

You mean something like this?

Select object_name(id) from dbo.SysComments where Text like '%ColumnName%'

Just my 2 cents... trading security for simple coding is rarely a good trade off.

HTH.

Check the execution plans when doing that. You'll see it doesn't actually always work (well anyways).

I think our profession is safe too... in our lifetime at least.

In what context do you need to do this??

Cause the answer can change from you need to go back to school or you need to use this admin sp

The authentication mode doesn't add/delete logins when changed, it change the access mode and nothing else.

This is the best article I've read on XML :

Is XML The Answer

Check out the articles section of the site for plenty more.