Update statment with L and R trim

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  February 24, 2009 at 9:39 am

  #131392

  How can I write update statment with this select statment?

  SELECT RTRIM(LTRIM(FIRST_NAME)) AS FIRST_NAME, RTRIM(LTRIM(LAST_NAME)) AS LAST_NAME, RTRIM(LTRIM(COMPANY_NAME)) AS COMPANY_NAME,

  RTRIM(LTRIM(A1)) AS a1, RTRIM(LTRIM(A1)) AS a2, RTRIM(LTRIM(CITY)) AS cITY, RTRIM(LTRIM(STATE)) AS STATE, RTRIM(LTRIM(STATE)) AS zIP,

  RTRIM(LTRIM(STATE)) AS ZENDER, RTRIM(LTRIM(ORDER_SHIP_DATE)) AS ORDER_SHIP_DATE, RTRIM(LTRIM(CountOrders)) AS COUNTORDERS,

  RTRIM(LTRIM(SumGrandTotal)) AS SumGrandTotal, RTRIM(LTRIM(PROD_DESIGN_CODE)) AS PROD_DESIGN_CODE, RTRIM(LTRIM(IS_REORDER))

  AS IS_REORDER, RTRIM(LTRIM(FPS_CODE)) AS FPS_CODE, RTRIM(LTRIM(NO_RENT)) AS NO_RENT, RTRIM(LTRIM(ORDER_CHANNEL))

  AS ORDER_CHANNEL, RTRIM(LTRIM(PAYMENT_METHOD)) AS PAYMENT_METHOD, RTRIM(LTRIM(AVAILABLE_DATE)) AS AVAILABLE_DATE

  FROM dbo.TblCust

  Thank you

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  February 24, 2009 at 10:05 am

  #949518

  Yulichka

  What is the objective of the Update T-SQL statement you are asking for assistance in creating?

  What was the database setting for ANSI_PADDING when these particular columns were created ...

  ANSI_PADDING explained in BOL at

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ac7e4c7c-e52f-4883-8f3c-9336cc77a9c8.htm

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]