select parentid from tcontentcategories where categoryid='#ID#' and siteid='#arguments.categoryBean.getSiteID()#' update tcontentcategories set path=replace(rtrim(ltrim(cast(path AS char(1000)))),,) where path like and siteID= select * from arguments.rsCurrent where categoryID=