×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Order By Statement, help please

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

RE: Order By Statement, help please

CODE

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  <--- 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

Just a small tip, when working with nested CASE's, add parentheses to make it easier to read and understand.

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

(OP)
thanks i got this figured out

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close