>Einar,
>Could you use COALESCE()?
>
>
http://msdn2.microsoft.com/en-us/library/ms190349.aspxHe could, only if the @field2 is NULL.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.