Thanks. That is what I ended up doing. Now the next stupid question. Why can't I use in GetDate() in a call to the function?

UPDATE  ORGANIZATION_Curr

SET     LocationCode =...