• 1) No, however if you're concatenating pieces of string together, you'll need a space somewhere.

    2) No. SQL doesn't care about whitespace. Lay things out that they are readable by you and anyone reading the code in the future.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass