p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_language thread: Select Case in SQL


Message #1 by ronp@c... on Thu, 7 Dec 2000 22:55:57 -0000
I was unaware that Access Sql supported Case
statements
unlike Transact-SQL

When you think about it you would create a sql text
string and build this up with CASE options etc.

then open recordset with the concatenated text string.

This of course is what Transact-SQL is doing anyway
parsing the text and resolving into a recordset.


You can of course use cascading IIF statements in
Access SQL and this can often achieve desired results


--- ronp@c... wrote:
> hi,
> 
> I would like to write a Select Case statement inside
> a SQL select query
> string to Access 8.0.
> 
> What's the syntax for that?
> 


  Return to Index