>Tore--
>
>I too find that most of his posts are rude or otherwise uncalled for. I can only recommend that you try to ignore him and let the 'water roll off your feathers'. So please do not feel as it is a directed solely at you - in general he is just rude in his approach in most any of his replies (I think your English is very good). In general, I find that he has a problem with his ego and he is 'always' right and his approach is the 'only' correct way. He may be trying to help but in the end he just causes people to ignore his responses. In general I do not bother to look at any of his posts because of his past responses (I actually had to view the thread as a whole to see his replies which definitely were uncalled for).
>
>Greg

See - the whole reason I am not bothering being nice anymore is because I said nothing rude or insulting to anyone yet I am attacked and oddly enough not one person sees any problem with that. Your comment here as well as Hugo's are the exact reason I have become tired of those who pretend to be nice. I stick to the technical matters which is all too rare.

Koen's question was solely to provoke a dispute. Hugo's also only wanted to debate semantics. I don't know why people cannot accept there are indeed very few good ways to do things and there are a lot of really bad ways to do things. I happen to collect the former and share them where needed. I'm not interested in anything half-fast. I see more value in correcting Tore than John because Tore will then spread the word to others like John. John, on the other hand, may work beneath others and they will already be blind and ignorant to best practices, having their own habits.

DELETED() is a dBase function. It takes an optional alias. You cannot use the alias in an SQL command. It's not just my opinion, but other MVPs also recommend not using xBase functions in SQL.