Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    19

    Unanswered: Simple case statement question,

    Can anyone help me with the following case statement? I keep getting syntax errors when I try to run..

    case when nlicense is null then "no series 7" else null end as rep_license

  2. #2
    Join Date
    Jul 2008
    Posts
    8
    remove the 'as'

Posting Permissions

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