Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Date: Fri, 12 Aug 2011 22:25:53 +0200 Organization: Erland Sommarskog Lines: 20 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="11474"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/GjZC1oOlxHEqKQuUDyofj" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:8yqW4jpLeyF386ei9rT4qWHM4+I= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:595 xo (xo5555ox@gmail.com) writes: > Thanks for the respond. I would like to provide the error message so > hopefully it will help. I know perfectly well what the error is. It's a very common question on the newsgroups. My previous post presented the cure for the problem, so know you know how to fix your query! (And let's hope that isnumeric does not find any false positives! -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx