Noel,

thanks, it looks like it will get the job done. I'll play around w/ it.

I've tried about a dozen different solutions, a brain teaser is fun sometimes.

Thanks again

yes

Thanks for your help,

but when the string is like this "'RECORD ANALYSIS ON 1/1/2008 (APPROX 400 PPS)'" it returns the date portion. Not the page count, any ideas?

I would rather do it via a stored procedure.