select mid as Id,
xmlquery('$CONTENT/movie/title/text()') as Title,
xmlquery('$CONTENT/movie/year/text()') as Year
from moviexml
where xmlexists('$CONTENT/movie/actors/actor/name[contains(., "Kramer")]');