Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unanswered: Update field from last character in a string

    I'm trying to figure a query that would update a field (HD) to = 1 if the last character in (Episodenum) is H.

    It seems so simple but I just can't wrap my head around it this morning. Thanks in advance!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    To update it:

    UPDATE TableName
    SET HD = 1
    WHERE Right(Episodenum, 1) = "H"
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •