NimbleUser.com
  • Products
  • Resources
  • Blog
  • Get Help
  • About
  • Products
  • Resources
  • Blog
  • Get Help
  • About

Blog

Thoughts on technology and innovation

SQL and iMIS Use of Underscores - Wildcard or no Wildcard

1/29/2009

Comments

 
Ellen Crooks, Application Analyst
In SQL and iMIS, the underscore is a wildcard for one character in a LIKE query.  i.e.  select * from orders where product_code like 'A_' will return all orders with product codes that are 2 characters in length and begin with an A. 
What if you wanted all orders with a product_code that begins with an A_?  Since the underscore is a recognized wildcard, using select * from orders where product_code like 'A_%'  will return all orders with product codes that begin with A.  If you want orders that have product codes that begin with A_, place brackets around the underscore: select * from orders where product_code like 'A[_]%'.
Comments
comments powered by Disqus

    Categories

    All
    Associations
    Culture
    Customers
    Member Loyalty Study
    Member Retention
    News
    Technology

    RSS Feed

Products

Nimble AMS
- Capabilities
- Success Stories
- Partners
​Nimble Sync

Resources

Blog
Case Studies
Webinars
Ebook

Get Help

Help Documentation
NimbleLand
Support

Company

About
Culture
Careers
​Contact

Picture
NimbleUser is now part of the Community Brands family. 
© 2018 All Rights Reserved NimbleUser 
Terms and Conditions
✕