I am using mssql and would like to search on a field where the second to last letter in the data is 'e'. I know in ms access i can use a '?' to denote a single letter and a '' to represent 1 or more letters. I have found in using sqlserver i use a '%' in place of '' but what, if any, char is the same as '?' from mas access?
regards
