[thelist] help with query Part I

Rob Agar rob at wildlime.com
Mon Oct 31 22:16:36 CST 2005


hullo

something along these lines perhaps:

	WHERE column LIKE '06%'

hth
Rob

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org 
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Casey
> Sent: Tuesday, 1 November 2005 2:04 PM
> To: The List
> Subject: [thelist] help with query Part I
> 
> 
> Hello!  Happy Halloween to everyone..
> 
> OK, the db in question had a column called mls containing an 
> id.  All id's 
> in this column start with a 0... some are 07xxxx, some are 
> 06xx, etc.  There 
> is no set number of total digits.  I need to select only the 
> rows where mls 
> starts with 06.
> 
> How would such a where clause be formatted?
> 
> TIA!!! 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 




More information about the thelist mailing list