Eugene Elutin (11/6/2012)
My favoured one is:
SELECT $
This also works for £ and € currency symbols. I'm not sure about other currency symbols like Yen, Roubles, etc, as it may depend on the regional settings for the environment or Collation for the DB/Server.
_________________________________________________________________________
SSC Guide to Posting and Best Practices