SELECT
  COUNT(*)
INTO
  :count 
FROM
  TypicalPictureVersion 
WHERE UPPER(name) = :name 
  AND typicalPictureID <> :typicalpictureID