In short, yes you can store line feeds in the table. However, is your question more about how to gather that information from the UI to store it? Maybe from a web form? If so you might want to post your question over to other sites such as
stackexchange.com. Just as an example: CREATE TABLE #test (NAME CHAR(100)) GO INSERT #test VALUES ('asdfasdf asdfasdf asdf asd') GO SELECT * FROM #test GO If you copy the results of the select out it should include the line breaks as well as the tabs.