Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

sandman · 12-13-2005, 06:08 PM

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.

12-13-2005, 06:08 PM	#3 (permalink)
sandman Junior Member Join Date: Jul 2005 Posts: 36	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.