case insensitive query

[m.sabitov]

Hi
How i can do case insensitive query with LIKE operator?

[leoknipp]

Hello,

can you please describe in detail which query you want to use.
Which part of the query shall be checked case insensitive?

Best Regards
Leopold Knipp
Senior Support Specialist

[m.sabitov]

SELECT ALERT '_alert_hdl.._text' FROM '*' WHERE '_alert_hdl.._text' LIKE "*Valve*" its work for "Valve", but not work for "valve" of "VALVE"

[thalter]

this should work
SELECT ALERT '_alert_hdl.._text' FROM '*' WHERE '_alert_hdl.._text' LIKE "*[v,V][a,A][l,L][v,V][e,E]*"

[m.sabitov]

maybe, but only for one word, i needed solutions for any words

[thalter]

If the SELECT is in a script you could convert the Search-Text with a function

Code: Select all

string convertText(string p_filterText)
{
  string r_wert;
  int i, i2, L1;
  
  L1=strlen(p_filterText);
  for(i=1;i

[mkoller]

Internally "LIKE" uses patternMatch(), however there is no way to tell it to ignore the case while comparing.
So: you can't

[m.sabitov]

Thank you Thomas, its good idea!
Martin you can think about implementing keyword UPPER and LOWER in wincc queri, its will very useful