Right. I think I have worked out what you are trying to do. Correct me on the following where I am wrong:
You have data stored in a database which is numeric, but written in Urdu/Persian.
The data is stored in an NVARCHAR or NCHAR field.
You require a method to convert this data from the Urdu representation to the Hindu-Arabic numerals like so:
? = 9
? = 8
? = 7
? = 6
? = 5
? = 4
? = 3
? = 2
? = 1
? = 0
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi