Thank you all for your great help, I solved the problem from my application.

I compared the new record, which I want to insert in my table, with some selected data(which...

Do you really have to check every single columns. Can't you do an exists check just on the primary key?

Yes, I have to check every column :-D, because...

I know there is no IsArabic(). is there any way to do so??

my table is ONLY 1 field containing arabic, english and numbers.

example(every row shows a record in my table):

????????

??????

?????

2005/12/14

left

Thank you for your reply.

I dont have type column.

Assume its only one column containing 100 rows some arabic words, some english word and some numbers.

I need to select only...

Thank you all for you replies

and thank you very very much Madhivanan, it worked for me and its done :kiss: 🙂

Thanks For Your Reply,

The problem is that The user cant run the EXEC() nor the sp_executesql.

The User can only run any storedprocedure which can only make select,delete,insert or update.

He cant...

Dear Russel Loski,

Thank you very very much for your effort and your work.

but because i found it beter for me to run this issue from my application, i.e my code,

I...

Sorry for being late,

I Attached a txt file which contains the contents of my .xml file (because i couldnt upload an xml file here).

if i import this file to MS...