I'm interested in searching a table with a string valued field for variable definition statements. The sub string would be "AS ..." I think this might be done effectively using a LIKE statement
However this will return the entire string containing the sub string, I'm only interested in the variable type, which comes three charterers after the A in AS. I can't use the Mid function, at least not in a trivial way, since the length before the AS varies. Anybody got a good idea on how to handle this?Code:SELECT [Raw Data].Field1, * FROM [Raw Data] WHERE ((([Raw Data].Field1) Like "* As *"));