Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005

    Unanswered: Trim Function question

    Is this the correct way to use the trim function? A grade may have 2 spaces before the letter or 2 spaces after the letter. And I want to trim both sides of the grade to get just the letter(s). This statement is in the query's where clause:

    trim(i.grade) in ('A','B','C','D','F','WF','I','E')

  2. #2
    Join Date
    Sep 2002
    That's correct.

Posting Permissions

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