Output Date field to Text field

• Roger Abram

  Hall of Fame

  Points: 3683

  More actions

  August 25, 2008 at 12:59 pm

  #71815

  I'm trying to update a text field with the value in a date field but without any slashes appearing in the text field.

  When I try this as the update statement convert(varchar(10),transaction_date,101), I get results like:

  03/20/2008

  What I really want are results like:

  03202008

  Is there an easy way to do that?

  Thanks!

  Roger

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  August 25, 2008 at 1:05 pm

  #862738

  Use REPLACE to remove the /