Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    124

    Unanswered: remove extra characters

    I have the following sql statement:

    SELECT FTE_CLASS_GROUP_NBR_DSCR
    FROM dbo.DLIST_FTE_CLASS_GROUP
    WHERE FTE_GRP_ID IS NOT NULL

    This is an example of the result returned:

    9999/00 Some lenghty text is displayed after the numbers

    I want to trim everything after 9999/00

    Is there a way to use rtrim to remove the characters after the numbers or another method?

    Thanks,
    -D-

  2. #2
    Join Date
    Jan 2004
    Posts
    124
    Please disregard...I found the solution. Thanks.

Posting Permissions

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