List:General Discussion« Previous MessageNext Message »
From:gary Date:July 4 2007 10:21pm
Subject:Re: How to Query by First Part of a VARCHAR?
View as plain text  
the thing to remember is that if you only want strings that start with 
CAT you'd never want to query with %CAT% because this could match 
DOG_CATHY.

% is a wildcard that matches any number of characters including none.

if you want to match a single character you use _

if you actually need to search for _ or % you can escape them with a 
backslash \% or \_
Thread
How to Query by First Part of a VARCHAR?David T. Ashley4 Jul
  • Re: How to Query by First Part of a VARCHAR?gary4 Jul
    • Re: How to Query by First Part of a VARCHAR?David T. Ashley4 Jul
      • Re: How to Query by First Part of a VARCHAR?Dan Nelson4 Jul
        • Re: How to Query by First Part of a VARCHAR?David T. Ashley4 Jul
          • Re: How to Query by First Part of a VARCHAR?gary4 Jul