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 TouchToneTommy 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: pibo
  • Content: Threads
  • Order by date
  1. pibo

    Varchar is back

    Hi, Thanks for your answers. I have found a way to get what I need, but it works only with Char type : SELECT * FROM table WHERE skill + level >= "4 " + "8 " Do someone have an idea to use this with Varchar. PS if i do this with Varchar, SELECT * FROM table WHERE...
  2. pibo

    Using Varchar

    Hi, I a table with 2 fields : skill [varchar(5)] and level [varchar(5)] What do I have to write with my SELECT statement to get all the records starting with skill = 4 and level = 8. ps : I don't want skill >=4 and level >= 8, if a record with skill = 5 and level = 1 exist, I want to have it...
  3. pibo

    Date Type and SQL Request

    Hi, I start recently with SQL, here his my first question : I have a table with a field in date type. What's the syntax in a SELECT request to get all records after Novembre 1998 ?

Part and Inventory Search

Back
Top