>>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)
William,
There is no STRTRAN() function in T-SQL :-)
It has REPLACE() one.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.