In addition to Gert's responce I have experienced with some situation that
after perfoming CHAR(13) +CHAR(10) it was still appear 'ENTER'
Here I think I prevent all(after that I did not encounter with the problem)
situations to have a 'ENTER'
> Yes, you can use the CHAR() or NCHAR() function for that (depending on
> whether you are using varchar or nvarchar). A carriage return is code
> 13, a line feed 10. On a windows system you will get a CR plus a LF, so
> CHAR(13)+CHAR(10). Use this with CHARINDEX or PATINDEX
> Hope this helps,
> > Hi
> > I've a VARCHAR column that corresponds with multi-line textbox. The
> > is that I need to extract the data into a textfile as a single line text
> > there are "Enter" key in the data causing the extracted line to be
> > multi-line too. Is there any method to detect those "Enter" key in the
> > Thx