Order By Statement, help please
Order By Statement, help please
(OP)
Hi
I have the below order by statement
ORDER BY CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL
THEN [Company] ELSE [First Name] END ELSE CASE WHEN [First Name] IS NULL THEN [Last Name] ELSE [Last Name] + ',' + [First Name] END END,
CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL THEN [Company] ELSE [First Name] END CASE WHEN [First Name] IS NULL
THEN [Last Name] ELSE [First Name] + ',' + [Last Name] END END
I keep getting error "incorrect syntax near the keyword "CASE""
Can someone please coach me
thanks
I have the below order by statement
ORDER BY CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL
THEN [Company] ELSE [First Name] END ELSE CASE WHEN [First Name] IS NULL THEN [Last Name] ELSE [Last Name] + ',' + [First Name] END END,
CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL THEN [Company] ELSE [First Name] END CASE WHEN [First Name] IS NULL
THEN [Last Name] ELSE [First Name] + ',' + [Last Name] END END
I keep getting error "incorrect syntax near the keyword "CASE""
Can someone please coach me
thanks
RE: Order By Statement, help please
CODE
THEN
CASE WHEN [First Name] IS NULL
THEN [Company] ELSE [First Name]
END ELSE
CASE WHEN [First Name] IS NULL
THEN [Last Name] ELSE [Last Name] + ',' + [First Name]
END
END,
CASE WHEN [Last Name] IS NULL
THEN
CASE WHEN [First Name] IS NULL
THEN [Company]
ELSE [First Name]
END <--- missing one else here probably
CASE WHEN [First Name] IS NULL
THEN [Last Name] ELSE [First Name] + ',' + [Last Name]
END
END
Regards
Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Order By Statement, help please
Also, the SQL Validator can be useful to find syntax errors:
http://developer.mimer.com/validator/parser200x/
(But then you'll have to use ANSI style "First Name" instead of [First Name], and || instead of +.)
RE: Order By Statement, help please