SQL Question Again - (hit enter and sent first attempt)

Discussion in 'MCSD' started by Guest, Sep 18, 2004.

  1. Guest

    Guest Guest

    Trying to create a search string to handle searching within an MSAccess TEXT
    field. Having problems when the variable is numeric
    Tried: (spaces expanded for clarity)

    strWhere = strFieldName & "= ' " & cstr(vVariable) & " ' " - raised an error
    when vVariable is numeric

    tried testing for numeric value first:
    if IsNumeric(vVariable) then
    strWhere = strFieldName & "=" & val(vVariable)
    strWhere = strFieldName & "= ' " & cstr(vVariable) & " ' "
    end if

    This also didn't work. What's the work around on this?
    Thanks in advance for any help offered
    Owen Schwer
    Guest, Sep 18, 2004
    1. Advertisements

  2. Guest

    Guest Guest

    Post question of this sort to the following:
    Guest, Sep 18, 2004
    1. Advertisements

  3. Guest

    Tom Dacon Guest

    For numeric values, it's:
    strWhere = strFieldName & "=" & cstr(vVariable)
    you want it come out something like:
    WHERE Price = 12

    for string values, you need to enclose the string in single-quotes, so it:
    strWhere = strFieldName & "= ' " & vVariable & " ' "
    you want it to come something like:
    WHERE State = 'Washington'

    There are better places than this to post programming questions, especially
    something like a question about an SQL query. Microsoft has many newsgroups
    that are devoted to programming subtopics. Why on earth would you post this
    to a newsgroup that's dedicated to Microsoft MCSD certification instead of
    one of those?

    Tom Dacon
    Dacon Software Consulting
    Tom Dacon, Sep 18, 2004
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.