Thank you for your reply and correcting my code. That parameter @EmpID I am trying to pass can't really passed into the function. I am having a gap I guess. My Application is always warning me "Must declare scalar value" for the function.