1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

How do I make one field be a function of another?

Discussion in 'SQL - Questions and Answers' started by stav, Jan 23, 2007.

  1. stav New Member

    Dialect: SQL 92
    I want to create a field that would be an AND function of two other fields in my table.
    stav, Jan 23, 2007
    #1

  2. Vincenzo Romano Guest

    Dialect: SQL 99
    You have two options.
    1. update the calculated field by means of a trigger for insertion and updates or
    2. create a view calculating the "virtual" field.
    In any case, updating the calculated field makes no sense at all.
    Vincenzo Romano, Jan 23, 2007
    #2

Share This Page