Home > IT Answers > SQL Server > Interesting Outout in SQL SERVER
Ashok tak
0 pts.
 Interesting Outout in SQL SERVER
SQL Server
Folks, If I query like this, am getting the following Output.. Y is this so ??? SELECT 10_to_100 _to_100 ----------- 10 SELECT 25_from _from ----------- 25 If anybody is familiar with the reason, y the part of the data in select query getting truncated.. pls share... :) cheers ! ash

Software/Hardware used:
ASKED: November 2, 2007  9:22 PM
UPDATED: December 2, 2007  11:15 AM
RELATED QUESTIONS
Answer Wiki:
The underscore is a special character for SQL Server. For some reason the SQL Server is parsing the data out at the underscore. When specifying text to select out you should place that text within single quotes. <pre>SELECT '10_to_100'</pre>
Last Wiki Answer Submitted:  December 2, 2007  11:15 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _