Search text is case insensitive and will search within a string.
For example: search for "mit" will yield "Smith" and "SMITH".
Total records in result = 0
Although your online search was unsuccessful,
please email us with your enquiry at email@example.com
SELECT * FROM PRODUCT_TBL WHERE prod_delete~*'0' INTERSECT SELECT * FROM PRODUCT_TBL WHERE PROD_CASNumber~*'382-45-6' ORDER BY PROD_Name3