Query for a single chracter not matching the letter S

D

DCA

Hello and thanks for the help.

I need the syntax that says, select the records where the 5th letter is not
S. The values look like this 1234A123. I need the query to select something
like this 1007E001, but not a value of 1008S002.

Thank you for all the help.
 
Top