[thelist] Quick SQL help

[Matthew Bernhardt]

SELECT * (or field list)
 FROM (yourtable)
WHERE Warehouse LIKE 'A*'

The wildcard you use in your WHERE statement will depend on what db you're  
using. Access, I think, uses * while MySQL uses %. Check the documentation  
for your db.

Hope this helps,
Matt

On Wed, 01 Mar 2006 09:54:01 -0500, Rob Smith <rob.smith at lexjet.com> wrote:

> Hi,
>
> Take a sample order (Order, SKU, Warehouse, Location):
> 1234 ____ ABC ____ A ____ 2
> 1234 ____ ADE ____ C ____ 40
> 1235 ____ EEF ____ C ____ 55
> 1236 ____ EEJ ____ A ____ 1
> 1236 ____ JJK ____ A ____ 1
>
> How do I narrow this list down to show all orders that had at least one
> "A" location in it?
>
> Thanks,
>
>
> Rob Smith
> LexJet
> rob.smith at lexjet.com
> http://www.lexjet.com
> (800)453-9538
> (941)330-1210 Int'l
> (941)330-1220 Fax
> 1680 Fruitville Road, 3rd Floor
> Sarasota, FL 34236
>
> Proud Sponsors of the Professional Digital Imaging Association  
> (www.pdia.org)
>
>



-- 
Matt Bernhardt, bernhardt.7 at osu.edu
Webmaster  +  Fab  Lab  Coordinator
Knowlton  School   of  Architecture
The    Ohio     State    University