Bill_Gates
$163 Billion Dollar Man
- Local time
- Today, 00:55
- Joined
- Oct 22, 2010
- Messages
- 11
So, I need to create a query to read values from a table that was created my multiple people.
Some people wrote in the Days Field: 1,2,3,4
While others wrote: 1.2.3.4
While others wrote: ALL
I could just clean up the data, but that might be futile because if we ever want to add data with an automated import, all of my cleaning would just get erased.
So instead, I simple want my query to recognize that all these text values actually mean the same thing.
Some people wrote in the Days Field: 1,2,3,4
While others wrote: 1.2.3.4
While others wrote: ALL
I could just clean up the data, but that might be futile because if we ever want to add data with an automated import, all of my cleaning would just get erased.
So instead, I simple want my query to recognize that all these text values actually mean the same thing.