[thelist] help with query Part I

Casey aspnet at thecrookstons.com
Mon Oct 31 22:03:58 CST 2005


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!!! 




More information about the thelist mailing list