Post reply

compare two strings

  • November 11, 2005 at 5:11 am

    #188437

    can anybody tell how to compare two character string in sql2k, as i did not find any function .

  • November 11, 2005 at 5:49 am

    #603394

    From Books OnLine:

    Comparison Operators

    Comparison operators test whether or not two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

    Operator Meaning

    = (Equals) Equal to

    > (Greater Than) Greater than

    = (Greater Than or Equal To) Greater than or equal to

    <= (Less Than or Equal To) Less than or equal to

    (Not Equal To) Not equal to

    != (Not Equal To) Not equal to (not SQL-92 standard)

    ! (Not Greater Than) Not greater than (not SQL-92 standard)

    The result of a comparison operator has the Boolean data type, which has three values: TRUE, FALSE, and UNKNOWN. Expressions that return a Boolean data type are known as Boolean expressions.

    Unlike other SQL Server data types, a Boolean data type cannot be specified as the data type of a table column or variable, and cannot be returned in a result set.

    SQL = Scarcely Qualifies as a Language

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply