"Doesn't seem to work" isn't a very descriptive clue as to what may be
wrong. Are you getting an error or just the wrong results? The way you
describe the select should be fine.
Andrew J. Kelly
SQL Server MVP
<KT> wrote in message news:phx.gbl...