Results 1 to 2 of 2

Thread: SQL Syntax

  1. #1
    Join Date
    Apr 2002
    Posts
    2

    Unanswered: SQL Syntax

    Hey
    Anybody know proper syntax for If, Then, Else? I've been using an excel spreadsheet with this: =if(F3>1,F3,0)... need to convert this to SQL... any ideas?


    Thanks

  2. #2
    Join Date
    Apr 2002
    Posts
    2
    Well, never mind, I answered my own question. In case anyone is interested I used:

    Iif([data_field]>1,[data_field],0)

Posting Permissions

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