Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LukeFilms

    query field for specific number of characters

    i want to query a column for records that have less than five characters in the field. ANy help would be great
  2. LukeFilms

    count seperate columns

    I want to have a dash board page that shows the total counts of info from certain columns but just can not get it to work "SELECT count(*) AS total_rows, count (MovieDvd) as total_dvd where MovieDvd = 1 from dbo.t_contacts " Total Rows Move DVD Interest 100 64 any ideas right...
  3. LukeFilms

    Sub Queries

    Works like a champ THanks!
  4. LukeFilms

    Sub Queries

    I am trying to pull contacts based on a radius of zipcodes. I can do this my manually putting the ZipCodes in the Queries fine. select Company,FirstName,LastName,Phone,ZipCode From dbo.t_contacts Where Church = '1'and ZipCode in...

Part and Inventory Search

Back
Top