How do you this with a text column field? Can't use replace.

I may have a workaround for now.  It's not great but it seems to work.  Since DOS commands work at the prompt I decided to create a batch file containing the file...

Unfortunately I have a similar case that seems more mysterious.

I am a local non-admin user of a WIN XP PC on a novell network and I am also a lone adminstrator of...

Okay I had the same need except I needed it to strip out leading zeroes and add digits.  I think the last one posted is the most flexible. 

But there's one...

Thank you folks for your quick feedback.

I forgot to mention that I already have simple recovery mode and that I was going to try disabling constraints (for the...

Pass the 'active' as the parameter for sp_who.

sp_who 'active'