Hi, Fortunately I found some kind of solution for the sorting problem, just after sending the mail. I was mixied with this problem for more than a week, but i don't know why I must find the answer after sending the question (beleive me)! May be some kind of holy spirit on this mailing list ;)
As I had talked personaly to some of the friends in this list before and we didn't find a reasonable solution, I hope this may be useful for some of you: 1. create a userdefined function: CREATE FUNCTION CorrectSort (@field char(100)) RETURNS char(100) AS BEGIN RETURN REPLACE(REPLACE((REPLACE(REPLACE(@field, 'Heh','$' ),'Waw','Heh')),'$','Waw'),'Keheh','Kaf') END use the exact farsi characted instead of the "Heh", "Waw", "Keheh", "Kaf". use any dummy char instead of "$") then use this function in the order by clase: SELECT * FROM Personal ORDER BY CorrectSort(Lastname), CorrectSort(Firstname) ---------------------------------------------------- BTW, I am still looking for some solution for substituting the Keheh with Kaf on data entry. ===== ....../--/| /--/|................................... ...../ /_// / /.................................. ..../ / /amidreza Younesy Aghdam .../ ___ / / Emails : [EMAIL PROTECTED] ../ /|_/ / / [EMAIL PROTECTED] ./__/ //__/ /omepage:http://ce.sharif.edu/~younesy .|__|/ |__|/....................................... __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com _______________________________________________ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb