CODEWITHSUNDEEP
comparessmsvarchar
user5286952
user5286952

Reputation:

how to compare varchar value in SQL server management studio

I can compare the values of varchar by using "LIKE" . For example

 CompanyName like 'google'

how can I compare it for dissimilarity. i.e, I want do 'companyName' is not equal to "google". How can I do it??

Upvotes: 1

Views: 143

Answers (1)

ljubomir
ljubomir

Reputation: 1525

You can use the NOT operator to achieve this:

CompanyName not like '%google%'

Upvotes: 1

Related Questions