Bob you are a legend! thanks..:-D

Hi Bob..

yep your right although error spewed by my adp .. it does run .. one thing though where i have text SELECT 'No rows...

Hi Bob..

thanks for the suggestion, i am somewhat a novice in these here sql parts :hehe: and struggling a bit.. Tried your suggestion and what i have is below.. but...

thanks bob..

Hi San..

Many thanks for your efforts, looks good and works if query finds a job but if 0 results Expr1 remains blank any ideas?

I'm trying to use this function but need my begin date to be today's date,

trying [dbo].fn_AddBizDays(GETDATE, 1) but not working does anyone know how to get this operational from...