Home Forums Article Discussions Article Discussions by Author Discuss content posted by Greg Goodge VARCHAR datatype RE: VARCHAR datatype

  • July 19, 2010 at 9:22 am

    #1194952

    Kanaka (7/19/2010)

    I am not sure why sql server 2008 returned 1, inspite of not giving the variable length.

    I knew this would give a syntax error, however, I tried this and it returned 1 row.:w00t:

    The version of SQL Server doesn't matter. The only way that you will get one record is if you are using a case-sensitive collation.

    Thanks,

    Greg