Professional Web Applications Themes

Using IF and IsNull statements in SELECT - Microsoft SQL / MS SQL Server

You would do something like this... select CustomerLastName + isnull(', '+CustomerFirstName,'') from tb -- -oj RAC v2.2 & QALite! [url]http://www.rac4sql.net[/url] "Christopher Dean" <hk4achotmail.com> wrote in message news:a2be76ca.0306291957.78ab5173posting.google.c om... > I am new to SQL in stored procedures and want to accomplish the > following: > > Pull [CustomerLastName] AND If [CustomerFirstName] is NOT null, then > insert "," and [CustomerFirstName]. Otherwise, insert " ". > > I have tried to accomplish this with the following code but get an > error when trying to save this as a stored procedure in an Access > Project linked to a SQL database. ...

  1. #1

    Default Re: Using IF and IsNull statements in SELECT

    You would do something like this...

    select CustomerLastName + isnull(', '+CustomerFirstName,'')
    from tb

    --
    -oj
    RAC v2.2 & QALite!
    [url]http://www.rac4sql.net[/url]



    "Christopher Dean" <hk4achotmail.com> wrote in message
    news:a2be76ca.0306291957.78ab5173posting.google.c om...
    > I am new to SQL in stored procedures and want to accomplish the
    > following:
    >
    > Pull [CustomerLastName] AND If [CustomerFirstName] is NOT null, then
    > insert "," and [CustomerFirstName]. Otherwise, insert " ".
    >
    > I have tried to accomplish this with the following code but get an
    > error when trying to save this as a stored procedure in an Access
    > Project linked to a SQL database.
    >
    > [CustomerLastName] & If(Not IsNull([CustomerFirstName]),", " &
    > [CustomerFirstName]," ") AS Name,
    >
    > There are, of course, many other fields that I will pull with a
    > similar test for null, but if anyone can point me in the right
    > direction on syntax for this first field I can take it from there.
    > Thank you in advance!

    oj Guest

  2. #2

    Default Re: Using IF and IsNull statements in SELECT

    Dear Dean
    Hope u are looking for this
    select lname + case isnull(fname,'') when '' then '' else ',' + fname end
    [emp name] from employee




    "Christopher Dean" <hk4achotmail.com> wrote in message
    news:a2be76ca.0306291957.78ab5173posting.google.c om...
    > I am new to SQL in stored procedures and want to accomplish the
    > following:
    >
    > Pull [CustomerLastName] AND If [CustomerFirstName] is NOT null, then
    > insert "," and [CustomerFirstName]. Otherwise, insert " ".
    >
    > I have tried to accomplish this with the following code but get an
    > error when trying to save this as a stored procedure in an Access
    > Project linked to a SQL database.
    >
    > [CustomerLastName] & If(Not IsNull([CustomerFirstName]),", " &
    > [CustomerFirstName]," ") AS Name,
    >
    > There are, of course, many other fields that I will pull with a
    > similar test for null, but if anyone can point me in the right
    > direction on syntax for this first field I can take it from there.
    > Thank you in advance!

    A Chandra Sekhar Guest

  3. #3

    Default Re: Using IF and IsNull statements in SELECT

    Thank you for the advice. I am still having issues with more complex
    strings in the SELECT statement and now it seems SQL will not accept
    strings over 128 characters! I may be back with a follow-up. Thanks
    again.


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Christopher Dean Guest

Similar Threads

  1. Replies: 4
    Last Post: February 27th, 01:22 PM
  2. Combing two simple select statements. There must be a way?
    By ukr_bend@yahoo.com in forum MySQL
    Replies: 5
    Last Post: March 24th, 06:10 PM
  3. Use MS Access to write SQL select statements
    By StylusDesigns in forum Macromedia ColdFusion
    Replies: 2
    Last Post: June 1st, 11:37 PM
  4. Replies: 2
    Last Post: May 14th, 12:55 PM
  5. recordset.recordcount return allways -1 on select statements
    By Sérgio Almeida in forum ASP Database
    Replies: 2
    Last Post: October 24th, 11:17 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139