b_cochofel
May 7th, 2003, 09:15 AM
Ok, I want to search a database for a keyword but I want people to be able to make mistakes with (i.e. 'têm' could be 'tem'), sorry for all english users, but I'm a portuguese and our language has this grammar issues...
I would like to replace 'ê' and 'e' for '%' to search in a SQL query, but I want to know if is another way besides using Replace() 2 times, first for 'ê' to '%' and then 'e' to '%'???
I would like to replace 'ê' and 'e' for '%' to search in a SQL query, but I want to know if is another way besides using Replace() 2 times, first for 'ê' to '%' and then 'e' to '%'???