f9c6b614   
   From: reb01501@NOyahooSPAM.com   
      
   xo wrote:   
   > Hello -   
   >   
   > I have a strange problem when casting value under 64-bit sql server   
   > 2005 vs under 32-bit sql server 2005.   
   >   
   > I got two servers.  One has 32-bit SQL server 2005 standard edition   
   > (version 9.00.3073.00) on Windows NT 5.2 (3790) with NT INTEL x86.   
   > The second server has 64-bit SQL server Enterprise edition (version   
   > 9.00.4035.00) on Windows NT 5.2 (3790) with NT AMD64.   
   >   
   > The problem came when I tried to cast value under 32-bit SQL server   
   > 2005, the result gets queried out.  But when the same sql got run,  it   
   > prompted conversion error - "Error converting data type varchar to   
   > numeric." under the 64-bit server.   
   >   
   > I tried cleaned up the data and it still gives the same error.   
   >   
   Please show us how to reproduce this symptom. You need to provide a script   
   that we can run on our servers to see the error you are getting. If the   
   problem occurs when using variables, that would enable you to easily create   
   a repro script:   
      
   declare @v1 , @v2 ;   
   set @v1=;   
   set @v2=cast(@v1 as );   
      
   Replace the <...>s with the actual data types and values required to   
   reproduce your symptom and post it here.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)