compare two columns

[econ]

I have a table that I need to compare two columns. Column A contains a string that should be part of Column B. For example, Column A is "Climber" and Column B is "High Point Climber". I need to find the rows where the string in Column A is not included as part of the string in Column B.

thanks

[pairbrother]

select * from tablename where instr(columnB, columnA) 

I think you'll have to look for the syntax of instr()

[sandman]

Give this a try:

select A, B
from yourtable
where B not like '%' || A || '%'

If needed on your particular server you may have to substitute the database's string concatenation operator for the standard SQL "double pipes" (||) operator.