Hi Mohammed,

Try taking the UPPER() functions out of the SQL. I'd only put them there so as to pick up if the same surname was in the database with a different case, such as REID or Reid. I think the problem might be that SQL Server doesn't understand UPPER().
Gavin...

>this is not foxpro table but this is a MS SQL Table
>
>Hope u have understood