1 Topic by prahousefamily (edited by prahousefamily 2016-02-01 07:16:03)

  • Registered: 2014-02-17
  • Posts: 365

Topic: How To Query "Like in Between" In long text Help Me Please

--table_A.DX
E110I10F23E458R206
E119I10
I10
I10E119E785K21
K21E785
--------------------------------------------------------------------------------------------------------------------------


How to query for search value in string by Like In Between

select
dx,
case when dx like between "%I10%" and "%I15%" then "Y" else "N" end as I,
case when dx like between "%E10%" and "%E149%" then "Y" else "N" end as E
from
table_A
Result Error

how To Display
--------------------------------------------------------------------------------------------------------------------------
table_A.DX                      I E
E110I10F23E458R206   Y Y
E119I10                             Y Y
I10                                      Y N
I10E119E785K21            Y N
K21E785                           N N

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: How To Query "Like in Between" In long text Help Me Please

I think it's impossible in your case.

Dmitry.