--- sol beach <[EMAIL PROTECTED]> wrote: > Of course you do. > You are asking for all of Telephone to be returned. > Duh! > >
> > 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%' > > > > Great response sol ! Why did you send it offline ? Wouldn't it be better to do some sit ups then take your frustrations out on me ? Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
