• Aah, yes, I forgot about these hex thingies which are convertible to INT. One of these strange days, I get following results

    SELECT ISNUMERIC(0X0e) AS E, ISNUMERIC(0X0f)  AS F

    E           F          

    ----------- -----------

    0           0

    (1 row(s) affected)

    while

    SELECT CAST(0X0e AS INT) AS E, CAST(0X0f AS INT) AS F

    E           F          

    ----------- -----------

    14          15

    (1 row(s) affected)

    works.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]