Archives of the TeradataForum
Message Posted: Wed, 21 Feb 2007 @ 12:28:14 GMT
| Subj: || || Re: SUBSTR query |
| From: || || Barry Hull |
| ||I've tried the above and it works. Thank you very much, for your help.|| |
| ||Can anyone explain what happened here? Why the Select worked as it was but the Update needed changing to the above?|| |
I would have expected the SELECT to work the same as the UPDATE (i.e. to fail with the error). I suspect that in the SELECT, the optimizer is
re-ordering the conditions as someone else stated, and that this allowed the SELECT to work.