Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-07 : 07:41:39
|
| Dilip Warrier Edakunny writes "Hi,I am trying to run the following query, expecting to see 'X'.SELECT * DUAL;But what i receive is a numeric value '9'. Is it because of some setting being done to return 9 instead of 'X'. Would like to know how this can be changed?thanks,Dilip." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-07 : 07:46:30
|
| >>SELECT *DUAL;Is it Oracle query?Better to post at Oracle forum of www.Dbforums.comMadhivananFailing to plan is Planning to fail |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-11-07 : 07:49:35
|
I have a question for you Dilip Warrier Edakunny.When you visited this URL http://www.sqlteam.com/askus.asp in order to send your question as a properly encoded HTTP request, did you read the text that says, in a bold and red font that says :quote:
We answer questions on Microsoft SQL Server here. No Oracle, no Access, no ASP, no mySQL. Just Microsoft SQL Server.
Well ?Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
SELECT * FROM DUAL returning value <> 'X'