Thanks Noel for the trigger info.

How about Union Selects - any suggestions on how I can get around this with text data types?

CCB

Thanks Guys.

Went with Gopi Nath Muluka's suggestion in the end.

CCB

Hi,

You are correct with your assumptions. It doesn't matter the order of the matches, only the amount, and null counts as a match.

Thanks

CCB

Thanks for the reply,

I will look into this.

CCB

That Worked.

thanks

CCB

Its ok,

I sussed it...

--Mark the ones we don't want (with null)

UPDATE @character SET marker = NULL WHERE (i < (SELECT MIN(i) FROM @character WHERE marker = 1)) or c in('-',...

Ryan

Thats works really well. Can I ask one final thing.

How would I extend it to replace - and _ with spaces.

Thanks very much

CCB

Thanks Scorpion.

I'll give it a go.

CCB

Thanks Ryan

Thanks Kenneth, I just realised that.

Getting the client to provide it won't hep when it comes to my Audit Trail Trigger. Any other ideas?

Thanks

CCB

Perfect.

Thanks very much

One final thing, do users need any special permissions to be able to run

exec master..xp_cmdshell 'ipconfig'

Thanks

CCB

Hi Andy,

I found that in BOL and it works fine.

Thanks for replying.

Any takers for IP Address?

CCB

Farrell, that worked a treat.

Thanks

CCB.

Thanks for the advice.

CCB

Many Thanks guys.

CCB