troubleshooting Question

Transact SQL challenge - Trim data after a special character

Avatar of Scudboy
Scudboy asked on
Microsoft SQL Server
5 Comments2 Solutions592 ViewsLast Modified:
I am trying to return a string up to a certain character, and cannot figure out what I should be using.  This may be a newbie question...
Basically, a varchar(255) column named COMMENT has the following value:
  'Working on a solution to get this to appear_NOT THIS'

When I select that column I would like the result to be
  'Working on a solution to get this to appear'

So effectively trimming everything to the right of the _ (underscore).

Is that even possible?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros