--- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > > --- Roger Baklund <[EMAIL PROTECTED]> wrote: > > Yes, I had not included in my original post I wanted just the area code returned. It works -
select SUBSTRING(Telephone, 1 ,3) from SignUp where Left (Telephone, 3) LIKE '4%' ; Thank you Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]