replace in sql 6.5

[Darth Vodka]

does anyone know the function(s) to do what REPLACE does in ss2005?

 

[SQL_Hell]

Hi,

Did a bit of reading around and it seems that the replace function also exists in sql6.5, have you tried it?

 

[Darth Vodka]

Hi,

Did a bit of reading around and it seems that the replace function also exists in sql6.5, have you tried it?

ah, think the error was more that i couldnt use replace with a datetime

have worked around it

thanks