Yes there's only one word in the field...

Also the table gets cleared nightly...

So you think that the trigger as is should work??

quote:

---

Is...

the data is scanned in, real simple just five fields. Just need to figure out the trigger...

IF EXISTS (SELECT rma FROM table1

WHERE rma = 'end' )

Then i would exec the...

quote:

---

This doesn't sound like a very efficient process, but if they are editing row by row and they simply enter end in...