On Thu, 8 Mar 2001 08:47:41 -0600, John Guynn wrote: >Is there a way to select just the first two letters in a column? I have a >column that contains values like TT1, TT2, TT3, TT4, PR1, PR2, RD1, RD2, >RD3, and I'd like to SELECT DISTINCT the first two letters. In otherwords >have the select statement return TT, PR, RD. -- Rod Buchanan Programmer/Analyst/List Manager/JOATMON KDS Internet Services http://www.kdsi.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]