Home Forums SQL Server 2008 T-SQL (SS2K8) CONVERT BEHAVIOUR RE: CONVERT BEHAVIOUR

  • November 7, 2012 at 1:47 am

    #1556666

    Jason-299789 (11/7/2012)

    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.

    Exactly!

    Guess what

    SELECT POWER(£,$)

    will return? :w00t:

    Proving (at SQL level) that money has no power! :hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]