 |
 |
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.
| |
