Re: Query

Actually, I have no idea what you are doing. What does the pound sign
accomplish in sql?

Have you tried this ...

select * from tblYourTableHere
where [PhoneNumber] Like '315*'

--

Danny J. Lesandrini
dlesandrini@xxxxxxxxxxx
http://amazecreations.com/datafast/



"Thomas A. Anderson" <NOSPAM_kayuman@xxxxxxxxxxx> wrote ...
>I have ran into a rut! I have google'd, Yahoo'd, but could not find the proper syntax. I have spent over two day
>trying to figure this out, and decided that I will have to ask for help from the experts!
> I have a table with three columns, LName, FName, Phone that I will be querying from.
> I would like to set a specific criteria for the Phone. I would only like to extract a specific area code:
> I have the following area codes under the Phone column: 212, 315, 347, 516.
> I would like only for 315 to show when I do the query.
> I have tried using the following syntax : ="315", ="(315)", "315", "(315)", "315""###-#####", "315 ###-####".
> Any ideas on what I am doing wrong?
>
> Access Newbie :(
> Thomas
>
>


.

Relevant Pages

  • Re: SQL Queries Questions
    ... "Seikyo" wrote in message ... > I use several SQL to do the stuff and Macro to link them I think. ... > will be a big trouble when the database get larger. ... Almost certainly there is a simpler way to accomplish what you want ... ...
    (microsoft.public.access.modulesdaovba)
  • Re: Securing the MDF file
    ... Some folks have used EFS to accomplish this. ... both successfully, and with dismal failures. ... The successes where with ... With SQL 2005, there are many excellent internal encryption capabilities ...
    (microsoft.public.sqlserver.security)
  • Subqueries and Aggregate Functions
    ... I am having trouble coming up with the correct SQL to accomplish a ... Most of the SQL I use is quite simple and I rarely have to ... SUMFROM tblEntryActivity act WHERE ... ent.colEntryID = act.colEntryID)) AS [Indirect Service Time], ...
    (comp.databases.ms-sqlserver)
  • Re: Group By - SQL Question?
    ... I WOULD LIKE THE SQL RESULTS TO LOOK LIKE THIS: ... How can I accomplish this - I am most concerned in ... RBrandt at Hunter dot com ...
    (microsoft.public.access.queries)
  • Re: How to make the SQL to run longer?
    ... To reproduce one of our cusotmer's probem, I need to make the SQL to ... have large amount of data in the database to simulate the dealy. ... If it is just a query, ... pound on the table with batch jobs until everybody slows down. ...
    (comp.databases.oracle.server)