>[SQL Server]Line 1: Incorrect syntax near '|' > >Does SQL Server 7 not support this kind of pattern matching? that's not pattern matching, the double pipes are string concatenation i'm sorry, i was using standard sql syntax, i think sql/server wants a plus sign instead =o) select '~' + term as wonkyterm from Glossary rudy