If you are using SQL2000 then you can use User defined functions. There you can write whatever logic you want. --Thanks Vilas