Re: php-db Digest 30 Dec 2003 12:07:25 -0000 Issue 2191

Try this: select LastName from MyTable where left(LastName,1) >= 'a' and left(LastName,1) < 'f';

How about Select LastName from sometable where LastName >= 'A' and LastName <'F' Hth Henrik Hornemann -----Oprindelig meddelelse----- Fra: Doug Parker [mailto:drparker@phreshdesign.com] Sendt: 29. december 2003 23:18 Til: php-db@lists.php.net; php-general@lists.php.net Emne: [PHP-DB] Selecting between using letters How would I create a select statement in MySQL that would return a range of records from the LastName field where the value starts with a designated letter - for example, returning the range where the first letter of LastName is between A and E... Any help would be greatly appreciated. ------------------------------------------------------------ http://www.phreshdesign.com