In MS Access I can do a format(Var, "#,###") and get a var with value 1000 expressed as 1,000. I've googled the format and it says that the equivalent for Format in SQLS2005 is convert. But what parameter ensures that a comma separates the ever 3 digits from the decimal?

What if I want 3 0s instead of 4 as comes by converting to 'money', style=2?
Can I define my own formatting/converting styles?