Search first chracters of string
1) I am looking for a solution to searching the first letter of a string e.g "A Good Day" but not "It Is A Good Day".
2) Similarly, I'd like to find first letters "A...B" which returns all records with a string starting with "A" and "B" but not text in the string beginning with A or B.
I assume it is a matter of writing a script that "calculates" the first letter(s) bur ignores the others, however, this is a guess and I wouldn't know how to write it.
Any help would be much appreciated.