Query That Is NOT A CASE SENSITIVE QUERY
Hi,
How do you create a query that is not a case sensitive and will show all data that has the same value from the first word?
For Example
=================
| ID | Account Name |
---------------------------
| 1 | Mike Studio |
| 2 | Wonderland |
| 3 | mike studio |
| 4 | mike |
| 5 | mike stdio |
================
OUTPUT:
=================
| ID | Account Name |
---------------------------
| 1 | Mike Studio |
| 3 | mike studio |
| 4 | mike |
| 5 | mike stdio |
================