Scott - PAX!

I was specifically responding to "internally SQL engine covert the select statement into loops and then fetch records from the tables...."

The "off at a tangent" bolt strikes yet again....the one common thread between almost every single post (that even smacks of controversy)....

It starts with "My favourite SSCer...." - talks about...

y'all's posts...I axe you....

btw...I noticed today that you've made a great impression on sufian...way to win people over!

...we should be so lucky...but mainly no one should be sent to divide by 2 if this happens...

How quickly you forget...you were the one who coined the term...don't want to spell it out...but remember when you asked me if I was not a ts & I got...

A template (if you will) that you can use to modify and configure specific db requirements so all databases created are "modeled" on the model db....

I don't think I understand the original requirements...

1) Are all actions going to be only "MODIFY" ?!

2) What are the DDLs of the other tables that you want to audit...

Okay Remi - you're a better man than I (and NO - je ne suis pas un ts...remember we've been through this before!)

Hopefully...

Meredith - try ND's solution and see it the substring function is supported:

update table set zipcode_2 = substring(zipcode_2, 1, 5)

...I also think you should definitely include the "where substring(zipcode_2, 6,...

ha ha! Yes indeed! You may cursor and loop all you want but if you run afoul of the fanatical members of the CursorsAreEvil religion (or those that are religious...

Okay - but that's a different requirement than what you outlined in your original post where the audit trail tracked ALL activities including delete, modify etc...

Ultimately, it's WHATEVER keeps the...

"..ready for flaming from the Open Sores guys.." -

hopefully a deliberate typo - funny that! - splly. since "flaming" & "open sores" sorta make for a very "OUCH" combination...

Steve - you may want to shoot a private email to Frank Kalis - a German and oldtime member of SSC who's written many articles of his own and would...

jwainz - you should repeat your comments under "my favourite SSCer.." - it might win you a t-shirt and/or books - Steve said so!

Remi - you'd wither away and waste...

You're welcome!

This link should set you off to a good start:

http://www.w3schools.com/sql/default.asp