question

aa007 avatar image
aa007 asked

Like Operator to filter

I am using Like operator to filter the condition. The data I have is 'MOM 12MN' . I want to remove all the record that has MOM in the beginning followed by space. Any suggestion please.
tsqllike
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Tom Staab avatar image
Tom Staab answered
You can use LIKE to filter for what you want. If you want to use it to exclude rather than include, just put NOT in front. I believe this is what you want: NOT LIKE 'MOM %'
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Glad I could help. Please accept the answer so others know the problem has been solved.
1 Like 1 ·
That just did the trick. Thanks Tom.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.