Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Location
    London
    Posts
    6

    Unanswered: what's wrong with this case statement?

    If anyone can help with this simple syntax issue:

    I keep getting a syntax error for the following statement:

    ============
    Select (Case when statement_secid = 'xyz' Then 1 Esle 0 End) as col1

    From tb_statement

    ============

    Thanks in advance

    L

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    only the "Esle" ...
    I do not see any error on syntax....
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Dec 2007
    Location
    London
    Posts
    6
    So obvious!

    That would be the answer....

    Thank you.

Posting Permissions

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