>I am updating some records of SQL Server database table. I am doing it in SSMS. The application that uses this table is VFP 9 and it has a report that prints these records. I need to insert two lines into a varchar(max) type field. Should I use char(10) or (char(13) to separate the lines? (I want to be sure that when printing the VFP won't have a problem)
>
>TIA
I think you should use char(13)+char(10) (e.g. CRLF)
If it's not broken, fix it until it is.
My Blog