Post reply

Cbyte Function

  • August 4, 2006 at 2:28 am

    #114067

    I am converting a query from Access 2000 to Sql Server 2000 and I am looking for a similar function to Cbyte. Any ideas?

  • August 4, 2006 at 6:03 am

    #653291

    CAST(YourField AS TINYINT)

    or

    CONVERT(TINYINT,YourField)

    Byte can hold values from 0 to 255 so the SQL Server equivalent is TINYINT

    SMALLINT is a signed 16 bit integer -32768 to 32767

    INT is a signed 32 bit integer

    BIGINT is a signed 64 bit integer.

    LinkedIn Profile

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

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