Paul White (2/16/2010)
dr_csharp (2/16/2010)
Yes Paul, data are numeric stored in NVarchar fields in persian. and the function i did, is going to convert any number to latin format.
Any other details you'd like to share? There's nothing worse than doing a whole heap of work, only for someone to turn around and say, "Oh yeah, I probably should have mentioned..."
Some sample input data and expected output would really help a lot.
Knowing the size of the data and how it is used and how important performance is to you would also help.
Thanks
Paul
1-as you know i asked this question and no one has appropriate answer after 2 days.
2-i converted all my past data, and change this function to a 'after insert trigger' to do conversion online.
3-nothing specific for sample, just seems a record have some normal data and 3 other fields ( Comment,Vote,Click ) in Persian representation.
i appreciate if you know better way or any alter that improve performance 🙂