Wildcard Searching

Hello, I am trying to add wildcard searching facilities to my search screen. I want to use % for searching on forname and surname. eg Bra% UPPER (FORENAME) LIKE 'BRA%' - Bradley - Bradshaw but also %MAD% -- Maddison -- Lomad Below is my existing search method ========================== private string BuildSearchSQL() { string strSQL; string strSQLSelect; string strSQLFrom; string strSQLWhere; strSQLSelect = "SELECT p.id, p.title, p.forename, p.surname, bu.unit_name, l.location, t.team_name "; strSQLFrom = "FROM PERSON p, VEC_BUSINESSUNIT bu, VEC_LOCATION l, VEC_TEAM t "; strSQLWhere = "WHERE p.BUSINESSUNITID = bu.ID(+) "; strSQLWhere += "AND p.LOCATIONID = l.ID(+) "; strSQLWhere += "AND p.TEAMID = t.ID(+) "; if (cboTitle.Text.Length != 0) strSQLWhere += "AND p.TITLE = '" + cboTitle.Text + "' "; if (txtForename.Text.Length != 0) strSQLWhere += "AND UPPER(p.FORENAME) = '" + txtForename.Text.ToUpper() + "' "; if (txtSurname.Text.Length != 0) strSQLWhere += "AND UPPER(p.SURNAME) = '" + txtSurname.Text.ToUpper() + "' "; if (cboBusUnit.Text.Length != 0) strSQLWhere += "AND UPPER(bu.unit_name) = '" + cboBusUnit.Text.ToUpper() + "' "; if (cboLocation.Text.Length != 0) strSQLWhere += "AND UPPER(l.location) = '" + cboLocation.Text.ToUpper() + "' "; if (cboTeam.Text.Length != 0) strSQLWhere += "AND UPPER(t.team_name) = '" + cboTeam.Text.ToUpper() + "' "; strSQL = strSQLSelect + strSQLFrom + strSQLWhere; return (strSQL); }

Here's some code that does the trick. It's not case-sensitive but it works. Try this: using System; using System.Collections; namespace csConsole { class WildCardSearch { static void Main(string[] args) { string[] strings = new string[] { "Apple", "Plane", "Car", "Pineapple" ,"Shower" ,"CarWash", "Grapple" ,"Shower" ,"CarWash" }; Console.WriteLine("Enter a term to search with...\n\n"); string term = Console.ReadLine().ToLower(); ArrayList tWildCards = new ArrayList(); foreach(string str in strings) { string ts = str.ToLower(); for(int i = 0; i < str.Length; i++) { if( ts[i] == term[0] ) { string t = string.Empty; for(int j = i; j < (i + term.Length); j++) { t += str[j]; } if ( t.ToLower() == term ) { tWildCards.Add( str ); } } } } Console.WriteLine("\n---------------------------"); Console.WriteLine("--------Wildcards----------"); Console.WriteLine("---------------------------\n"); for(int i = 0; i < tWildCards.Count; i++) { Console.WriteLine( (string)tWildCards[i] ); } Console.Read(); } } }

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

bilnaad22y ago
Here's some code that does the trick. It's not case-sensitive but it works. Try this: using System; using System.Collections; namespace csConsole { class WildCardSearch { static void Main(string[] args) { string[] strings = new string[] { "Apple", "Plane", "Car", "Pineapple" ,"Shower" ,"CarWash", "Grapple" ,"Shower" ,"CarWash" }; Console.WriteLine("Enter a term to search with...\n\n"); string term = Console.ReadLine().ToLower(); ArrayList tWildCards = new ArrayList(); foreach(string str in strings) { string ts = str.ToLower(); for(int i = 0; i < str.Length; i++) { if( ts[i] == term[0] ) { string t = string.Empty; for(int j = i; j < (i + term.Length); j++) { t += str[j]; } if ( t.ToLower() == term ) { tWildCards.Add( str ); } } } } Console.WriteLine("\n---------------------------"); Console.WriteLine("--------Wildcards----------"); Console.WriteLine("---------------------------\n"); for(int i = 0; i < tWildCards.Count; i++) { Console.WriteLine( (string)tWildCards[i] ); } Console.Read(); } } }