View Single Post
  #2 (permalink)  
Old January 17th, 2007, 12:31 PM
agossage agossage is offline
Authorized User
 
Join Date: Dec 2006
Location: Lake Wylie, SC, USA.
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The CASE statement is incomplete. THEN is required to determine the result of the case.
(i.e. SELECT * FROM table WHERE table_id = CASE WHEN (1 = 1) THEN 1 ELSE 0 END)

What are the two original statements?


Adam Gossage
Lake Wylie, SC, USA
Reply With Quote