Hi Frans, Some time back i remember seeing a post where you have mentioned it is better to use Select columnName rather than select * in our queries. Could you tell me why this is an advantage/better thing?

Thanks.

Im not frans, but i thought that i will drop in.

1. Selecting the columns by name is better, as you only get the columns that you want - so this is better for performance purposes.

2. By specifying the names also saves SQL the hassle of finding the columns names.

3. If the SQL contains joins from other tables selecting Tbl.* is very bad as you can have name conflicts (Table with same field names) .

Thanks Wayne. Appreciate it.