[RESOLVED] Replace function

Hello friends,

Ive one field called adrdress in my database table. It has got linefeed character in that as address is stored using multiline text box. but I want ot print the same address in one line crytal report. so i want to replace linefeed character with space. i tried replace function like this replace(address,chr(13)," ") but it is not working.

plz help me soon.

reagrds
damini

13 is the Carriage Return character. 10 is the LineFeed character.

Try Chr(10) and if that does not work try replacing both of them.

thx brucevde. It solved my problem. I've to replace both.