Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Used case in select query
November 03, 2010
Used case in select query?
Posted Date: November 04, 2010 Points: 5
Wat is your doubt?
do u want know about use of case in select query?
Thanks and Regards,
Posted Date: November 08, 2010 Points: 5
According what i understand is that you want something like how case is used in select query in sql.
Basically SQL CASE is used with "when-then-else" functionality (WHEN this condition is met THEN do_this) kind of.
For example, you can use it as follows
'Status' = CASE
WHEN quantity > 0 THEN 'in'
Hope this helps.
To post reply
Related Questions Related Questions
Can we use Case Statement in Update Query?
How do we use CASE WHEN statement in ms access query and please give me sample?
CASE WHEN Statement in MS Access query
Select query to check existence of foreign key
getting Error for accessing Data from MS Access using Select Query
Select Query in sql server
query handling in asp
Having a doubt in SQL query
How can we select a particular row in the listview control
User can not select TEXT for copy paste from my .aspx page...
Latest Forum Questions From The Same Category
What are the methods available to access the XML
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend