frank, try mattias' solution, and if it doesn't work, please let me know which dabatase system you're using here "SQL" can describe any number of systems, and they can have different UPDATE statement syntaxes...