I am trying to create a query to search a field and retrieve records that contain specific characters within a string. The obvious answer is to use wildcards. But let me try and elaborate: Below are 3 records in a dataset. All of these records contain the character combination “14”.
Record 1. “114; 244; 142; 14; 144”
Record 2. “377; 210; 68; 144; 444”
Record 3. “14; 237; 114”
I would like to query these records for the number “14” only. So, a successful query would retrieve Record 1 and Record 3. If I use the wildcard character “*”, then the query result set will contain all 3 records, so this is out of the question.
Is there another wildcard character that I can use that will allow me to search for records that specifically contain the number “14”? (as opposed to “114”).
I hope I am making myself clear. This is quite new to me.
I would appreciate any answers.
Record 1. “114; 244; 142; 14; 144”
Record 2. “377; 210; 68; 144; 444”
Record 3. “14; 237; 114”
I would like to query these records for the number “14” only. So, a successful query would retrieve Record 1 and Record 3. If I use the wildcard character “*”, then the query result set will contain all 3 records, so this is out of the question.
Is there another wildcard character that I can use that will allow me to search for records that specifically contain the number “14”? (as opposed to “114”).
I hope I am making myself clear. This is quite new to me.
I would appreciate any answers.