I'm ok with your sample but the result is not what I was expecting.
Try to do the same test with Char fields, you'll see that you'll get "MSE" "LOW" in your recordset. Because, as MSE is greater that "MS", it have to appear...
I would rather like to use varchar to reduce the size of my database.
The Recordset I want to have in my last example should be :
"MS" "LOW"
"MSE" "LOW"
"XS" "HIGH"
What I want to do is simple : I want to get a Recordset starting with a special skill an level.
Let take another example :
Here are some records :
skill level
"MS" "HIGH"
"MS" "LOW"
"MSE" "LOW"
"XS"...
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...
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...
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 ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.