I have a table called plants a column called contract.
In this column I have numbers like the following:
I need to write a query that will return all contracts with ac in them.
I know that if I had just the ac or acd etc in the column I could write a query as follows:
where contract ='ac'
But how can I get all contracts with ac in them even if the first portion of the column is anywhere from 4 to 10 numbers then the letters??