This is what does work...

  mgr_ad_id  = ' + ''''+@ad_id+''''

thank for your help lucky... you pushed me in the right direction.