SQL update mit substr

[Fuerchau]

update cptfil/Rech set thcmt = substr(thcmt, 1, 29) concat '®' concat substr(thcmt, 31, restlänge)
WHERE substr(Thcmt, 30, 1) <> '®' and
TTDTE between 20070707 and 20070708