[thelist] Help with a replace loop

[Shinji Kuwayama]

on 6/12/01 2:13 PM, rudy limeback at r937 at interlog.com wrote:

> just do this
> 
> <cfquery name="getWonkyTerms" datasource="theDataSource">
> select '~' || term  as wonkyterm
> from Glossary
> </cfquery>
> 
> that way each wonkyterm will have the wonky character at the front, and you
> don't have to do a replace on them

That looks pretty cool - I tried it and got:

[SQL Server]Line 1: Incorrect syntax near '|'

Does SQL Server 7 not support this kind of pattern matching?

-- 
Shinji Kuwayama
Director, Internet Development
http://www.internetcoach.com/