>No Borislav, what am looking for is the statment it self like is there any case option on ms sql do the job. or any other statment can do the job on a better way.
OK, What result you want if BOTH are empty?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.