Pinku

Pinku

  • 1.4k
  • 304
  • 45.8k

How to Include Punctuation in Like operator

Oct 9 2024 5:19 AM

I have below data in Database: This is an example only. Data may be change
sustainability- energy
sustainability. energy
sustainability/ energy
sustainability; energy
sustainability* energy
sustainability: energy
sustainability, energy 
sustainability energy

Current query is : select * from Table where description Like '%sustainability energy%'
I want to write a query which will return all above data .It should not be like '%sustainability%' because we dont what data may come. just an example.sustainability energy is a user search data.If it contain special character then also it should find.

 


Answers (2)