Daniel
Reputation: 9
How to use NOT LIKE in SQL with a string of words
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.
Upvotes: 0
Views: 77
Answers (0)
Related Questions
- How can I prevent SQL injection in PHP?
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to return only the Date from a SQL Server DateTime datatype
- How to add a column with a default value to an existing table in SQL Server?
- How do I UPDATE from a SELECT in SQL Server?
- How to query MongoDB with "like"
- How can I do an UPDATE statement with JOIN in SQL Server?
- SQL Update from One Table to Another Based on a ID Match
- How can I delete using INNER JOIN with SQL Server?