SQL Query Fails for some records

79 Views Asked by At

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.

0

There are 0 best solutions below