Kind of an odd requirement to check for scientific notation. Not sure there is exact but maybe something like this?

;with SomeVals (CharVal)

as (

select 'AKN12345' union all

select 'REC12345' union all

select '12.47e43'...

There are lots of people around that can and will help. However what you posted is not enough information to even fully understand your question let alone be able to...

SELECT SYSTEM_USER

Well we do get MENtal pause. I have often found that this is the...

Well I hope it doesn't take that long...Labor Day is not until September....

I posted Gail's favorite yesterday in case you missed it.

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

What would you do if @ObjectDB = 'YourDB'? If you do a bunch of hard coded conditionals this proc will out...

You will to convert the entire thing to dynamic sql.

You can reference objects from any database on the server with full 3 part naming convention (database.schema.object)

Using a variable like...

blampe (5/25/2012)

---

I don't think I'm being clear enough, what I want is the procedure to run so it will replace all of the table values under ssn with COMPLETELY DIFFERENT...

If you want some real help read the first link in my signature. You need to provide a lot more details about what you are trying to do before anybody...

blampe (5/25/2012)

---

use Brett_Test

GO

if exists (select * from sysobjects where type = 'P' and name = 'countSSN')

drop procedure countSSN

GO

create procedure countSSN

as

set nocount...

Your assessment of cursors in a trigger being a bad idea is correct. Cursors can be really bad for performance and inside a trigger can be one of the worst...

Yeah there is no sure fire way to do that. One recommendation is to rename the objects instead of deleting them. For example if you have table called "Employees" that...

sturner (5/25/2012)

---

Sean Lange (5/25/2012)

---

I can remember on many occasions when it was windy we would fly backwards. Just pick a spot and point straight into the wind, slow down to...

I can remember on many occasions when it was windy we would fly backwards. Just pick a spot and point straight into the wind, slow down to just above stall...