Hi folks! I'm asking in a web form for clients, those clients I have to search them into OFAC SDN lists( http://www.ustreas.gov/offices/enforcement/ofac/sdn/delimit/index.shtml), if they are into that list they wont be able to do transactions in my system.
My problem is to perform a good search of the names into that list, I had thought in fulltext, but it appears to not work. Fulltext works with short names. does anyone have any suggestion for this? Regards! Edwin.