We help IT Professionals succeed at work.

How to obtain the "line return" in SQLMS

Hi !

My address column contain "line return" in the data. When I use MS SQLMS to query my DB in don't see the line returns but insted I see a double space for each line return.

Is there a way for me to query the DB while seeing the "line return" or even better : do a founction like in MS Excel "text to column" but directly in my query ?

Thanks

-M
Comment
Watch Question

Author

Commented:
That is very intresting, but do you know how to switch from grid view to text view in the query results ?

Commented:
there is option in the tool bar. you can check.. I forgot the shortcut :(