Return rows that contain B12

[Uzma Shaheen]

Hi all,

What query can i write to return rows that contain B12 in Oracle?

I have tried

select addr
from addresstable
where instr(addr,'B12') > 0

And have tried this

where addr like '%B12%'

why wont this work?

thanks

 

[Uzma Shaheen]

bump anyone?

thank you

 

[Uzma Shaheen]

bump anyone?

thank you

Why has this thread been moved?

i applogise if i have posted incorrectly

 

[Joe4]

Why has this thread been moved?

It appears to be an Oracle question, not an Excel question.
Is that not correct?