Sorry Max

I missed the part in your earlier post where you said the job step contains "exec dbo.sp_abc". If that is the case, ignore my previous post.

Hi Max

Check whether the owner of the object is dbo - it may not be. Even if you have sysadmin privileges, if you are connecting to Query Analyzer using your...

Looks like we may have to do the same.

Thanks for your advice

Thanks JohnG

As I mentioned towards the top of my post all the single numeric and alphabet characters have been removed from the noise file. Would "3" still be treated as...

Do you mean that the actual data in the cust_name field has quotes around it, ie 'ABC (After Breakfast Corp.)'? If the quotes are actually in the data itself then...