Results 1 to 4 of 4

Thread: converting null

  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Unanswered: converting null

    Hi,

    In oracle we can convert a null value to any value with the NVL Function.
    Pls tell me the equivalent in Access.


    Regards,
    Yoel

  2. #2
    Join Date
    Jul 2002
    Location
    Romania
    Posts
    122
    Nz(Expression, ValueIfNull)

    HTH

  3. #3
    Join Date
    Mar 2003
    Posts
    2

    convering <Oracle>length function

    Hi,

    What is the MS Access function has the same functionality as <oracle> length function
    Regards,
    Yoel

  4. #4
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    len([field_name)

    this returns the length of the field as an integer

Posting Permissions

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