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.

SELECT LEFT(column) FROM table

-- or --

SELECT SUBSTR(column, 1, 2) FROM table


Rod Buchanan
Programmer/Analyst/List Manager/JOATMON
KDS Internet Services

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]

Reply via email to