Using Varchar

[pibo]

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

 

[Andel]

Have you tried using "OR" instead of "AND" ?

Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[riya]

hi,

I think u can do this by using the like operator along with the case statement in ur select query.