Great!! so that helps to answer something that i had to know too, i should put the whole select after the first Fecth not just the cases.

in other words put...

Ok , i was put on another project and back to this one and i realize

i need to be selecting in the cusor on this one and not updating....

Ok , i was put on another project and back to this one and i realize

i need to be selecting in the cusor on this one and not updating....

No, but I think he does not know anywork way around and i dont know one either. I suggested that I tyr to do what is needed with out a...

What seems obvious after u have done it once (with your alls help that is)

relieves me, and keeps my feeling of stupidity a secret to u 'all and not my...

thank you very much!!!

thanks very much for you help and time!!!

thanks all, i will try it! Is it difficult to configure sql to use email or net send??

thanks all for your help!!!

Thanks All!

perfect, so a left join and left outer join is the same thing ie, outer is implied when you just type left join?

Like this?

Insert Locations

(L_ID, LocationName,...)

Values(1023, QuoteName(Mann'ys Pizza))

supper thanks!

cool, so all i have to do is instead of trigger and it runs the replace function only on records being inserted/updated before they are inserted??!!

HaHa! Thanks all for the help