converting english numbers to arabic numbers and vice versa


 

hi,

 

i need convert english numbers arabic numbers , vice versa.

 

we can convert datetime hijari date (arabic date) using convert function.

do have similar way number conversion?

 

regards,

sachin

hi,

did soln this? have similar requirement, convert english arabic numbers , vice versa.

kindly let me know if found solution.



SQL Server  >  SQL Server Tools



Comments

Post a Comment

Popular posts from this blog

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

Getting error when using Excel Destination

Image
i getting error when using   transferring data oledb source  to excel destination i using dynamic file connection means each time new file generated @ desination folder getting error given above path stored in variable @[user::path] :c/admin/ for creating excel file using expression excelfile path: @[user::path] +(dt_str,4,1252) datepart("yyyy",getdate()) +right("0"+(dt_str,4,1252) datepart("m",getdate()),2) +right("0" + (dt_str,4,1252) datepart("d",getdate()),2)+ right("0" + (dt_str,4,1252) datepart("hh",getdate()),2)+right("0" + (dt_str,4,1252) datepart("mm",getdate()),2)+right("0" + (dt_str,4,1252) datepart("ss",getdate()),2)+".xls" now when clicking on exceldestination component mapping getting error ================================= error @ insertingdatafromexcel de...
Read more