|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | SQL Query - Rider Name Contains Reserved Word | |
| jeff 7/17/2010 1:27:17 PM | --quote: Great program, I got the HDW subscription and so far some eye-opening data. One problem: On the data screen, I am trying to do an SQL query for a rider name "SUTHERLAND CHANTAL", however the query always fails. When I go back to the SQL query, it has tokenized the SUTHERLAND and assumes the AND in her name is part of an sql query string and I can't complete the query. Any work around? Query I am trying to run: SELECT * FROM STARTERHISTORY WHERE INSTR('SUTHERLAND CHANTAL', RIDER) > 0 I get zero results, go back to SQL query box and see that it shows: SELECT * FROM STARTERHISTORY WHERE INSTR('SUTHERL AND CHANTAL', RIDER) > 0 Thanks! --end quote-- My reply: See the below linked to text file. It contains examples of two "work-arounds." The first example uses two separate lines where the INSTR command is used... the second example uses two separate lines using LIKE: http://www.JCapper.com/MessageBoard/Reports/Impact_Study_RiderName_AND.txt -jp . ~Edited by: jeff on: 7/17/2010 at: 1:27:17 PM~
| |
| JustRalph 7/17/2010 10:44:16 PM | wait a little while and it will all change to SMITH problem solved
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |