I am just looking for the short command so I can bring up addresses that start with a letter A-Z and not a number. This is just so I can do a visual look over these address that don't start with a number and mark them of as bad and exclude them from mail merges etcI can then chase them up for next time. I presume there is something where in SQL I can go where like = "something * ". I have already got this working the long way by doing like "a*" or like "b*" through the whole alpahabet ;). Work ok I can easily identify the bad addresses it bring up PO Box also doing it that way.
Expand|Select|Wrap|Line Numbers
- SELECT *
- FROM STD
- WHERE STD.Address Like "a*"
- Or (STD.Address) Like "b*"
- Or (STD.Address) Like "c*"
- Or (STD.Address) Like "d*"
- Or (STD.Address) Like "e*"
- Or (STD.Address) Like "f*"
- Or (STD.Address) Like "g*"
- Or (STD.Address) Like "h*"
- Or (STD.Address) Like "i*"
- Or (STD.Address) Like "j*"
- Or (STD.Address) Like "k*"
- Or (STD.Address) Like "l*"
- Or (STD.Address) Like "m*"
- Or (STD.Address) Like "n*"
- Or (STD.Address) Like "o*"
- Or (STD.Address) Like "p*"
- Or (STD.Address) Like "q*"
- Or (STD.Address) Like "r*"
- Or (STD.Address) Like "s*"
- Or (STD.Address) Like "t*"
- Or (STD.Address) Like "u*"
- Or (STD.Address) Like "v*"
- Or (STD.Address) Like "w*"
- Or (STD.Address) Like "x*"
- Or (STD.Address) Like "y*"
- Or (STD.Address) Like "z*"