SQL Query

Question

I am trying to develop an SQL query like that :

UPDATE Query1 SET Query1.type = Switch(type Like 'sh*' Or 'katastima','shop',type Like 'ipi*','services',type Like 'ka*','cafe',type Like 'TE*' Or 'ktiria tepak','tepak',type Like 'per*','kiosk',type Like 'esti*','restaurant',type Like 'farm*' Or 'Farm','pharmacy');

But my data doesn't change as i want. Could anyone make a suggestion?

Answer 1

Hi. When you have more than one condition to check, you'll need to have both sides of the comparison for each condition. For example, if you want to check if Type starts with "sh" or if it is equal to "katastima," then you would use something like:

[type] Like 'sh*' Or [type]='katastima'

Hope that helps...

Answer 2

Hi, Marios Simou

from your query its looks like you are matching a case in 2 languages. so if user spell like any of one that case should executed and set the value. but you have to match it correctly. because it is possible that user give some input but your code doesn't have that criteria to match at that time you will not get the proper output. so make your code that match your criteria thoroughly.

for more reference please visit the link below.

Access wildcard character reference

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.