Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: SQL DB Query Help

    Hi Everyone!

    Is it possible to do an SQL satement to the extend:

    If "ConsID" is not null then use the "Full Name" and "T3" on that same record and then only display "Emma miles".. like two records attached.. (couldnt figure out how to insert image)

    Thanks in advance!
    Attached Thumbnails Attached Thumbnails image.png  

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Have a read about CASE expressions: CASE (Transact-SQL)
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2010
    Location
    Atlanta, GA
    Posts
    211
    Provided Answers: 1
    It's hard to understand what exactly you are trying to do. Can you post something like a mocked up BEFORE and AFTER to show what the code is supposed to do?

    Like gvee said, CASE is probably the function that you are wanting to use based on the cryptic information you provided.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •