- Searching within a string

Searching within a string

In WOW, there are a few different ways in which you can search for specifics within a string value. Whether it is a search for a symbol, character, numbers, or multiple characters within a string, you can do any of the following:

• add a wildcard to the beginning and or end of a search string.

• using LIKE in an SQL query (will place a '%' at the end).

  • setting the Field Class property of a field to: Wild Card % Prepended Field (will place a '%' at the front).

Note: A wildcard (%) is a substitute for zero or more characters.

Click here for detailed information using a wildcard (%) and LIKE within an SQL query to search within a search string value in WOW.

For more information on using wildcards (%) in SQL, visit: http://w3schools.com/sql/sql_wildcards.asp

For more information on using the LIKE in SQL, visit: http://w3schools.com/sql/sql_like.asp