Update is not updating the whole string
Posted
by
Malik
on Stack Overflow
See other posts from Stack Overflow
or by Malik
Published on 2012-12-12T10:38:27Z
Indexed on
2012/12/12
11:03 UTC
Read the original article
Hit count: 182
Following is my SQL fiddle: http://sqlfiddle.com/#!2/f9bae/1
In which i am trying to check if the whole name is being verified by lookup table or not and if there is any error then it should get replaced by the correct value but the problem i am facing is that if any name contains more than one wrong values then query only update one part of that name and leave the rest unchanged , kindly let me know how can i modify my query for update so it'll update the whole name as per lookup table correct values.
Thanks,
© Stack Overflow or respective owner