Querying in Database help?????? (1 Viewer)

[th]

how do u these in a query????


how do u find all people whose family name contains the letter "a"

 

[goan_crazy]

A query is a search within a databse
you go for
WHERE surname=a

 

[melsc]

or if you want the SQL statement it would be
SELECT (all the fields you want to show up...i.e. last name, first name, address etc)
FROM (name of table)
WHERE LastName="A"
ORDER BY (which field asc or dec)

 

[drewgcn]

how do u these in a query????


how do u find all people whose family name contains the letter "a"

Do you mean, what is the SQL (structured query language) used to form that query?

Or how do you create a query in say, Microsoft Access?

For the former...the above two posts have the answer.

If it is the latter, the Microsoft Paperclip is your friend !

 

[Delta32]

Actually the question was contains "A". Therefore;

SELECT (fieldnames to be displayed)
FROM the relevant tables being queried - eg, customers
WHERE Lastname Like "*a*"

 

[rithvikt]

how do u these in a query????


how do u find all people whose family name contains the letter "a"

jus simply use the wizard for the queries and drag in the appropriate fields....in the criteria section of the family name field put in 'a' and RUN the thing...u should end up wit the desired results