0

I have table with 3 columns Month, Name, Sales.
In the Month column is data like "Jun'18, Jul'18 ..."

So how can I use "Jun'18" in where condition without using LIKE function.

Hans Kesting
  • 38,117
  • 9
  • 79
  • 111
Rajasekhar
  • 3
  • 1
  • 2
    Possible duplicate of [How do I escape a single quote in SQL Server?](https://stackoverflow.com/questions/1586560/how-do-i-escape-a-single-quote-in-sql-server) – Onkel Toob Jun 26 '18 at 07:33

1 Answers1

2

You'll just have to escape the single quote like this:

SELECT * FROM TableName WHERE Month = 'Jun''18'
Onkel Toob
  • 2,152
  • 1
  • 17
  • 25