RE: SQL Question

[Anthony Geoghegan]

>SQL server chokes on this. 
>Replace() is a valid TSQL function, I guess I need something like DE() in
>CF...

>Any ideas?

Just use single quotes.

        SELECT * 
        FROM   tblNames
        WHERE  replace(firstname+lastname,' ','')='#who#'
It should work now.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists