I'm running a query where I'm selecting records that contain a word in a VarChar2(4000) field. The query works but only for some dates and not others.
I've tried REGEXP_LIKE and INSTR. I've tried it in SQL Developer and ACCESS and I get the same results.
Oracle:
REGEXP_LIKE(Table, 'Text')
INSTR(Table,'Text', 1)<>0
Access:
(((Table) Like "*" & "Text" & "*"));
Case sensitivity is not the issue.
Has anyone else seen an case like this before?
Edited to show sample data:
**Job Date Description**
1 6/6/2017 Blah Blah Text Blah Query works and finds Text
2 6/6/2018 Blah Blah Text Blah Query can't find Text
The same query works for any date prior to 2018.