Replace in an SQL Statement??

[PDL]

I have tried:

SELECT Test, Replace(ItemName," ","_","ALL&quot AS Description

in orer to get rid of SPACES in the contents of the variable ItemName. Keep getting errors. Any ideas?

 

[GunJack]

I think you're just mising the # in your statement. Try this:

SELECT Test, #Replace(ItemName," ","_","ALL&quot# AS Description

Inside <cfquery> tags, all CF variables and functions need #s around them.

Hope this helps,
GJ