0

I am having trouble excluding text in a field that starts with "Community Launch". I am using the code:

rp.project_name NOT LIKE 'Community Launch%'

but this is removing any text that also has Community in it. I need for it to remove text that starts with Community Launch.

I have tried different variations and searched, but I am unable to resolve.

Improve this question
8
  • try: SELECT * FROM your_table rp WHERE rp.project_name NOT LIKE 'Community Launch%' COLLATE Latin1_General_CI_AS AND LTRIM(RTRIM(rp.project_name)) = rp.project_name Commented Jun 4, 2024 at 12:38
  • 3
    The condition actually looks OK. Can you share some sample data and the expected vs actual result you're getting? Commented Jun 4, 2024 at 12:47
  • 2
    NOT LIKE should of course work too. However, I can't see why your query doesn't work as expected. Provide a minimal reproducible example, showing the problem. And a prepared dbfiddle.uk would be great. Commented Jun 4, 2024 at 12:47
  • 2
    @ErgestBasha Why shouldn't they use NOT LIKE? Commented Jun 4, 2024 at 13:10
  • 2
    Either way we cannot reproduce this dbfiddle.uk/1MKOIcuQ please give a minimal reproducible example Commented Jun 4, 2024 at 13:25
Related questions
1990
How to query MongoDB with "like"
4347
UPDATE from a SELECT
3327
How to add a column with a default value to an existing table in SQL Server?
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.