Thanks, AnzioBake. Books Online suggests a preference for patindex on text columns, but does not say charindex won't work (as was the case with SQL 7). But I had tried...