Re: Using Wild card characters inside command statements

[Ray ferns]

Hi PB,

Thanks for your reply,

1) Yes, my roomtype variable is like the way you described. It is declared as varchar (40) with texts such as: "lab", "Lecture theatre 1", "Lecture Hall" etc.. I want to allow a search from the start i.e. Lecture% should return "Lecture Theatre" and "Lecture Hall"

2) RoomNo follows the same procedures as 1) like "A4.1", "C.21" "LT1" etc...

3) What I understand of GROUP BY clause is that the the field column divides a field in to groups, which could have repititive names. For instance in my example query, I want to list the roomNo in groups based on the RoomType and Capacity of room

Thanks,