Results 1 to 3 of 3

Thread: query problem

  1. #1
    Join Date
    Dec 2009
    Posts
    2

    Unanswered: query problem

    Hello

    Is that possible to INSERT some TEXT into TABLE but only in that fields where where values are only DECIMAL:

    for example:
    1. invoice a | 13424
    2. Invoice b | 13632fv
    3. Invoice C | 12455623

    I want to add that text into 1 and 3 row. How to do that ?


    greetz
    Krs

  2. #2
    Join Date
    May 2009
    Posts
    258
    Sure it's possible, just use IIf and IsNumeric, something like as follows:
    Code:
    InvoiceNum & IIf(IsNumeric(InvoiceNum), 'text', '')
    Regards,

    Ax

  3. #3
    Join Date
    Dec 2009
    Posts
    2

    re

    is that sql code??

Posting Permissions

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