Home Forums Article Discussions Article Discussions by Author Discuss content posted by John Arnott Varchar or Char? RE: Varchar or Char?

  • October 19, 2009 at 7:14 am

    #1067603

    Fatal Exception Error (10/19/2009)

    How efficient will char be if you have throw an rtrim() in the where clause?

    Not as efficient, but why would you want to use RTRIM in a WHERE clause? Even if you are restricting by length, SQL Server won't be counting the built in padding.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers