>Hi,
>
>Thanks you for quick answer but we still the same problem special with names like the following exmple:
>
>DECLARE @L_SQLCOMM VARCHAR(8000)
>
>SET @L_SQLCOMM = 'SELECT * FROM AMASTER where ACCTNAME = (ala'a)'
>
>EXEC(@L_SQLCOMM
>
>"ala'a " is Arabic name in English characters.
>
>Regards

Try ..

DECLARE @L_SQLCOMM VARCHAR(8000)

SET @L_SQLCOMM = strtran("SELECT * FROM AMASTER where ACCTNAME = (ala'a)","'","''")

EXEC(@L_SQLCOMM)