[thelist] Help with a replace loop

rudy r937 at interlog.com
Tue Jun 12 16:24:04 CDT 2001


>[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






More information about the thelist mailing list