>In my view designer on the filter tab I set my criteria to 'like'. When I search for example the letter 'O' to find state beginning with 'O', I don't get anything, but yet there are state such as Oklahoma, Ohio etc.. in my table. Can anyone help me please?
>
You need to use the proper templating for the LIKE clause; take a look at the documentation for the SELECT SQL topic in the on-line help. LIKE uses a wild carding scheme; the
% matches 0 or more undefined characters, and an
_ matches exactly one character. in a LIKE clause:
O% matches anything beginning with "O"
_O% matches any string whose second character is "O"
%O matches anything that ends with "O"
O%K_ matches any string beginning with "O", and whose second to last character is "K"
>Nick Patel