October 26, 2005 at 12:06 pm
Hi
I have a comments field in my table of datatype varchar(500).
Now thru the application calue is being stored in this.When somebody writes the comments and uses enter key then it is stored here also.
Now when I try to write this text in a file thru an application then the text after the enter key is shown in the next line in the notepad.
So how do I check for this enter key in the comments field and remove it...
October 26, 2005 at 12:25 pm
replace(replace (column, char(10), ''), char(13), '')
why don't you want to keep that information in the db??
October 26, 2005 at 1:53 pm
Hi
Well tx a lot..That solved the purpose....Could you please explain a bit too this solution..
Well the report just needs to me made and the text has to come in one line..No chnages in the Db....
October 26, 2005 at 1:55 pm
A return is composed of a return cariage line feed and (hence the constant vbcrlf in vb to insert a return). The replaces I gave you delete those 2 characters removing the return.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply