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 in my recordset.
Thanks
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 in my recordset.
Thanks