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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to