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. Any ideas? John Guynn This email brought to you by RFCs 821 and 1225. -- 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]