Error in Update query

• DerbyNeal

  Hall of Fame

  Points: 3854

  More actions

  March 18, 2010 at 10:45 am

  #386535

  Hi,

  I am trying to update columns within a table when several conditions are true (see below).

  UPDATE dbo.LSR_Prep

  SET

  Result = RTRIM(LTRIM(Crude_Result)),

  Result_4 = '1'

  WHERE

  RTRIM(LTRIM(Analysis_Code)) = '58'

  AND

  ISNUMERIC(RTRIM(LTRIM(Crude_Result))) = 1

  AND

  RTRIM(LTRIM(Crude_Result)) > 3;

  However, the following message is displayed:

  Msg 245, Level 16, State 1, Line 2

  Conversion failed when converting the nvarchar value '1.611226611' to data type int.

  All the columns are data type nvarchar. The 'Crude_Result' column contains numeric and alphanumeric data.

  Any ideas?

  Thanks in advance,

  Neal

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  March 18, 2010 at 12:06 pm

  #1136195

  The ISNUMERIC function is not as it appears. See this[/url] thread for details.

  John Rowan

  ======================================================
  ======================================================
  Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden