Hi, As I've told before, we can define User Defined functions, in SQL Server. So we may have a function with a simple hash table, mapping the characters into our defined sort order. Then we can simply use the function in the "ORDER BY" clause; e.g. (SELECT * FROM PERSONAL ORDER BY CorrectSort(lastname)" It is also possible to use triggers to store the converted data (instead or together with the real data), if we have a large amount of records. Using the convert function in the ORDER BY clause, will be very slow specially because we do not use the Indexes. As I talked with some of the committee members, they told, they are going to publish a semi-standard for Farsi sorting. I think after having such a thing, someone may write a general function to be used by all.
===== ....../--/| /--/|................................... ...../ /_// / /.................................. ..../ / /amidreza Younesy Aghdam .../ ___ / / Emails : [EMAIL PROTECTED] ../ /|_/ / / [EMAIL PROTECTED] ./__/ //__/ /omepage:http://ce.sharif.edu/~younesy .|__|/ |__|/....................................... __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com _______________________________________________ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
