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: *

  • Users: apnea
  • Order by date
  1. apnea

    Sql query, find keywords in a string

    Carp thank you for your answere, you qery is working fine without restrictions for capital or small leters.But i like to do one thing more e.g I have this string: "On site technical assistance" When i try to search something like: "on technical" the result should be the...
  2. apnea

    Sql query, find keywords in a string

    I have a Field in my database that contains strings. (VARCHAR2)I like to build a search page which is working like a search engine (without any restrictions, capital or small letters etc.)What is the sql query for this purpose? Thak you for your help
  3. apnea

    select from Date data type table column

    krkX do you use oracle?
  4. apnea

    select from Date data type table column

    Yes carp im using oracle. Your query returns an empty table, i think the problem is that the column includes olso the time: 7/22/98 8:00:00 AM. I dont now, can you suggest something? Thanks
  5. apnea

    select from Date data type table column

    I like to select from a Date data type column years and months. The contents of this column have a specific format: e.g 7/22/98 8:00:00 AM. When i try to make a qery e.g SELECT * FROM TASK1_TABLE WHERE Task_Table1.START_DATE LIKE '%22/98%' the result is an empty table. How can i select...

Part and Inventory Search

Back
Top