--- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I'm storing telephone number (US) in 10 digit > varchars. If I want to do a search on just the area > code, is there a way to limit it to just the first 3 > digits of the string ? > > Thank you > Stuart >
I'm trying something like this but still getting back the whole string: select Telephone from SignUp where Left (SUBSTRING(Telephone,1,3), 3) LIKE '4%' Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
