or more accurately WHERE mls LIKE '06%' > -----Original Message----- > From: thelist-bounces at lists.evolt.org > [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Rob Agar > Sent: Tuesday, 1 November 2005 2:17 PM > To: thelist at lists.evolt.org > Subject: Re: [thelist] help with query Part I > > > 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 ! > > > > -- > > * * 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 ! >