I want to partition a table.. not on a PK column but say on a category > 2000..

What is the syntax for doing that ?

If I want to delete all the records greater than 2000 category ( truncate that partition), can some one help me with that syntax ?

Can I take out that partition after doing this ?

thanks