Using if statement in SQL from MS Access

anonymous_at_discussions.microsoft.com
Date: 07/21/04

  • Next message: Steve Kass: "Re: Using if statement in SQL from MS Access" 
    Date: Wed, 21 Jul 2004 01:58:40 -0700

    HI,

    I am new to SQL but have experiene in access. I would like
    to convert the following from access SQL to proper SQL.
    Can anyone help. How should this be done in SQL??

    [new_field_name]: iif([fieldname]="Help","HELP",
    [fieldname])

  • Next message: Steve Kass: "Re: Using if statement in SQL from MS Access"

    Relevant Pages

    • RE: Conection between SBS 2002 Premium
      ... About SQL, I will collect more information because the developer guy still ... features of SBS to fit on my scenario. ... > Thank you for posting to the SBS Newsgroup. ... >>- There is communications between both NT4 for access SQL Application ...
      (microsoft.public.windows.server.sbs)
    • Re: SUBQUERIES in the FROM clause with Access query
      ... change all the table names with the original working sql. ... I learn alot with access sql after this. ... "Tom Ellison" wrote: ... > without this, as the alias was in use in the "original query" you posted, ...
      (microsoft.public.access.queries)
    • Re: Right Join (?)...
      ... I don't believe *= and =* work with Access SQL, though, do they? ... that was a SQL Server dialect only. ... >> I have a query that pulls a field from the results of another query and ... >> FROM [Master Table], GetInvoiceData, ExportLog ...
      (microsoft.public.access.queries)
    • Re: Mutivalued datatypes considered harmful
      ... and well off topic for this group - what would a sql query ... or would it somehow convert the multi-value field into a single ... are the extensions to Access SQL a "standard" or a Microsoft fudge to ...
      (comp.databases.pick)
    • Re: access sql ouside sbs network
      ... I want to buy sbs 2003 R2 Premium and I want to access sql serwer from ... some computers across internet. ... Beyond those scenarios, SBS CALs would be needed for every remote user or device used to access SQL, even if consolidated through a website, and that's likely to be impractical. ...
      (microsoft.public.windows.server.sbs)