So I'm seraching for the string, 'Blackhawk' and I want to realize this MS- SQL Statement in SAPDB :> Am I able to make such a fuzzy LIKE Statement in sapdb ?
... LIKE '%[bB][lL][aA][cC][kK][hH][aA][wW][kK]%'
It might be dramatically faster to do:
upper(col) like '%BLACKHAWK%'
If this is something you want to do a lot then you probably want to split the col data into words and index the word table so you can do indexed, case insensitive searches.
-- Regards Flemming Frandsen - http://dion.swamp.dk PartyTicket.Net co founder & Yet Another Perl Hacker
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
