Rubicon2009
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
there is option in the tool bar. you can check.. I forgot the shortcut :(
ASKER