dhanekulakalyan (4/26/2016)
Thank you I need to check with ltrim(rtrim(avg(datesdiff))) to get in one row. I will keep you posted .
LTRIM() will remove leading spaces, RTRIM() will remove trailing spaces. Again tabs are not spaces, so they will be unaffected by LTRIM()/RTRIM().
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA