Actually my value has the closing parameter. I must have have missed it when I copied the sql to paste on this forum