Hi Danny, you wrote : > (...) > > So I'm seraching for the string, 'Blackhawk' and I want to > realize this MS- > SQL Statement in SAPDB : > ... LIKE '%[bB][lL][aA][cC][kK][hH][aA][wW][kK]%' > > But that doesn't work in sapdb, so I want to ask : > > Am I able to make such a fuzzy LIKE Statement in sapdb ?
In general there is no regular expression syntax in a LIKE pattern. It has only the wildcards '%' (substring of arbitrary length) and '_' (exactly one character), which can optionally be escaped, cf. http://www.sapdb.org/7.4/htmhelp/8c/ccce27c71c11d2a97100a0c9449261/content.htm in your special example you could use the UPPER (or LOWER) functions : ... UPPER(<somecolumn>) LIKE '%BLACKHAWK%' HTH --- Markus Stausberg SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
