Post reply

Trimming column values in place (without temporary tables, etc)

  • September 4, 2013 at 8:11 am

    #277648

    I have four tables containing the regular chars and varchars. Unfortunately, no one bothered to trim the values of white space before inserting them into the columns. Is there a way to ltrim(rtrim()) in place without resorting to temporary tables or variables?

    I guess I could use a cursor but there has to be a better way.

    Thanks!

    John

  • September 4, 2013 at 8:25 am

    #1647335

    it is actually pretty straightforward :

    update table set varcharcol = ltrim(rtrim(varcharcol))

    The probability of survival is inversely proportional to the angle of arrival.

  • September 4, 2013 at 9:09 am

    #1647362

    That makes sense. Too bad I don't have any!

    Thanks a million!

    John

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply