--- Roger Baklund <[EMAIL PROTECTED]> wrote:
> It's a bit unclear what you are trying to do. Are > you trying to find all > numbers within a 3 digit area code, i.e. numbers > starting with some 3 > digits? Or are you trying to find numbers with any > of the three first > digits equal to 4? > > For the first case, area code 444: > > SELECT Telephone FROM SignUp > WHERE Telephone LIKE '444%'; > > ... and for the second case, finding the digit 4: > > SELECT Telephone FROM SignUp > WHERE LEFT(Telephone,3) LIKE '%4%'; > > Thank you Roger. It's the 2nd case. Yes, using LEFT worked but as you saw , I was also trying to do a substring so the return would only have the first 3 digits (the area code). Perhaps that needs to be a seperate line of code. Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]