>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
Every single quote MUST be doubled, no matter if the string is name or something else:
SET @L_SQLCOMM = 'SELECT * FROM AMASTER where ACCTNAME = (ala''a)'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
