Post reply

Trimming question

  • May 9, 2002 at 11:42 am

    #172998

    Hi there,

    I've been trying to trim off one letter from the right out of a field the way the fields data was entered was lastname first initial. No last name field. In the name of normalization I need to change that. So what you see is "Mayer L" I just want "Mayer" I can't seem to find a way to do it. I tried replace and the right function, but neither seems to do the trick. I know I am missing something simple. Could someone push me in the right direction? Thanks

    Laura

  • May 9, 2002 at 11:59 am

    #428824

    How about

    rtrim(left(last_name,len(last_name)-1))

    or left(last_name,len(last_name)-2)

  • May 9, 2002 at 12:03 pm

    #428825

    Thanks so much! That was it. Thanks again.

    Laura

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

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